You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

prompt table

6 replies [Last post]
Guest's picture
Guest

hi
will you please explain me how to to change the state field based on the country field

anithan's picture
User offline. Last seen 10 years 30 weeks ago. Offline
Joined: 06/29/2010
Posts: 31
Re: prompt table

please answer it...

Ashar's picture
User offline. Last seen 5 years 1 week ago. Offline
Joined: 03/26/2008
Posts: 227
Re: prompt table

If the State field Prompt record has Country as a Key field then State should be displayed based on the Country selected. It should work automatically.

anithan's picture
User offline. Last seen 10 years 30 weeks ago. Offline
Joined: 06/29/2010
Posts: 31
Re: prompt table

but ...
these are delivered tables .so it works
but for user defined tbales
how to do it?
i heard that we have use views.?
thanks
anitha n

Ashar's picture
User offline. Last seen 5 years 1 week ago. Offline
Joined: 03/26/2008
Posts: 227
Re: prompt table

Funda is..
If you have a fields A & B on the page, and you want to populate the prompt list of field B based on value of field A, then Prompt record for Field B should contain Field A as a high level key.

anithan's picture
User offline. Last seen 10 years 30 weeks ago. Offline
Joined: 06/29/2010
Posts: 31
Re: prompt table

kkk
but
it not coming direclty we have to write dynamic sql view to populate the values in the send field(B)

Ashar's picture
User offline. Last seen 5 years 1 week ago. Offline
Joined: 03/26/2008
Posts: 227
Re: prompt table

I dont think you need to write dynamic view for this. An SQL table or view should work just fine.
Just make sure the Field A is before Field B in the page order. It might affect the processing.