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.

How to get respective states for country field

3 replies [Last post]
Guest's picture
Guest

Hi All,
I am designing a page where I need to get all the states information for selected country i.e in a page if I select country ddl as usa in the next drop down list I wants to select specific states respective to usa. Can any one give me the elaborate information for above scenario

Ashar's picture
User offline. Last seen 4 years 31 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: How to get respective states for country field

Use COUNTRY_TBL as prompt for COUNTRY field and STATE_TBL as prompt for STATE field.

Raju's picture
Raju (not verified)
Re: How to get respective states for country field

Hey hi , I did the same thing my fields on page are

county name ---------------- properties: prompt table edit , prompt table :country_tbl
state relevant to country -------------- properties: prompt table edit , prompt table :state_tbl

Here I am having two questions
one is When I did the same thing as mentioned above country prompt is showing all countries ,but when clicking state prompt button its coming as 'no matching values were found'

Second thing do i don't need to write people-code to suite this requirement simply by giving prompt table edit , we can get relevant states for the country field ?

Ashar's picture
User offline. Last seen 4 years 31 weeks ago. Offline
Joined: 03/26/2008
Posts: 227
Re: How to get respective states for country field

You don't need to write any code for that.

Make sure that the name of the field on the page is COUNTRY & STATE.

If you have COUNTRY as key in the prompt table for STATE then component processor displays only the States under the selected COUNTRY.