Question
Create drop down based on drop down
Lets say I have a table that contains 50 states and I query
and produce a dynamic drop down list. Is it possible to create
another dynamic drop down list based on a selection from the first
drop down list (both have to be on the same form) ?
For example, if I select TX from the states drop down, then the second drop down, which is city, should show me a list of cities in TX, as a drop down. If I select NY from states, then the city would show cities in NY as a drop down, etc. The city dropdown should change dynamically based on the state drop down selection.
How can this be done ?
For example, if I select TX from the states drop down, then the second drop down, which is city, should show me a list of cities in TX, as a drop down. If I select NY from states, then the city would show cities in NY as a drop down, etc. The city dropdown should change dynamically based on the state drop down selection.
How can this be done ?
AdChoices