I'm having trouble with a form that displays 3 drop down lists.
Dropdown #1: The user selects a value from a drop down list. The list is populated by a table.
Dropdown #2: The user selects a value from a drop down list that is populated based on his selection in Dropdown #1.
Dropdown #3: The user selects a value from a drop down list that is populated based on his selection in Dropdown #2.
Each of my tables will have a dozen or more possible value. Below is a more brief example:
Dropdown #1 asks you for gender and displays possible values from a table that includes only 2 option, male and female.
Dropdown #2 asks you for your favorite Olympic sport and the list displayed contains no sports that are male only.
Dropdown #3 asks you what sporting gear you need to buy used in the sport selected in drop down #2.
So if you picked female in #1, #2 would show you a list of female sports including synchronized swimming. Then #3 would show you things like bathing cap, nose plug etc.
Anybody have code that will do this?


