Load values to a dropdown box on a Repeating table based on another dropdown box selected value

mgovind — Wed, 08 Jul 2009 10:53:03 GMT

hi,

I have a repeating table with 2 droppdown box fileds Country, State.

When i am creating New Record, first i will select a country from first dropdown box, then the 2 dropdown box should display only the states of the selected contry.

When i perss Run Query , it is display the selected country & State.

Is there any way to achieve this?.. Give me some idea , so that it will be helpfull do fix this issue.

I tried this by creating a rule like this,

Set a field's value:@State_Id=""
Set a field'd value: strCountry_Id=.
Query using a data connection: GetStatesForaSelectedCountry

But it doesn't helps me to achieve the solution.....

General

Load values to a dropdown box on a Repeating table based on another dropdown box selected value