Dependent select list

Hi All,

Please is it possible to set up dependent select list between two fields that get their values from the recordset? E.g the values of "State" will be dependent on the selected value of "Country".

Please what are the steps if possible.

Cheers.

use Dynamic Drop Downs


You should have 2 tables:
Country:
CountryID - Primarykey
CountryName

states:
stateID - primary key
stateCountryID - foreign key to country.countryID
stateName


for the parent list create a recordset:
SELECT * FROM Country

Set the list to be dynamic. In the dynamic properties for the list, set the value to the CountryID column, and the label to the CountryName column.

Create a recordset for the states:
SELECT * FROM states

The add a Create Dynamic Array server behavior to the page, set the parent ID to the stateCountryID, set the Child ID to the stateID, set the child name to the stateName column.


now, in design view, select the parent list, on the behaviors panel click the plus button and select Dynamic Drop downs -> Populate List From Array

Set the parent list to the country list and the child list to the state list.

Thank you Jason this si really clear on how to achieve it, but when you are in a registration page with captcha and you didn't insert the right captcha value when you press submit the form doesn't clears and tells you the value is wrong, but your selections in the lists clears. How can you make the lists not to clear?
Thank you in advance

On the body tag, use the set selected in list behavior with the Validated entries binding on the Onload event, also add a populate list from array behavior.

the idea is to use the set selected in list for the parent list, a populate list from array behavior to populate the child list, then a set selected behavior to make the selection in the child list.

Hi Jason, I don't understand how to do it.
I accomplished to do a dependent select list, what I want to do is: when I submit the form and the form doesn't pass the server validation, all of the form entries stay in the form so you have to correct only the field you inserted wrong, I can accomplish this with all the items in the form, but the only ones that doesn't retain their input values are the ones of the dependent select list. I am using a dependent list on countries and states.
Thank you for your help.

in the tag selector, select the body tag.

on the Behaviors panel, click the plus button and select WebAssist -> WA Dynamic DropDowns -> Set Selected In List.

For the target list, select the parent list.

For the value, click the lightning bolt icon and select the corresponding element from the Validated Entries Collection.

click the plus button again, this time select WebAssist -> WA Dynamic DropDowns -> Populate List from Array. and set up the dynamic array the same as you did for the onchange event of the parent select list.

click the plus button once more and select WebAssist -> WA Dynamic DropDowns -> Set Selected In List.

For the target list, select the child list.

For the value, click the lightning bolt icon and select the corresponding element from the Validated Entries Collection.

make sure these 3 behaviors are added to the onload event of the body tag.