I have multiple combo boxes that must update based on the selection in the first box.
The first box works fine. However I can not get the second box to work.
Here is my code for the first box:
select COUNTY_NAME as QuestionOption from IA_COUNTY
My second box takes the selected county and pulls a list of cities in that county.
Second box code:
select NAME as QuestionOption, TOWN_ID as QuestionOptionValue from IA_TOWNS where COUNTY=@county
No matter what I do the second box doesn't populate.
The shortname for my first box is county.
The shortname for the second box is city.
Hopefully someone can help me with this.
After I get this box working I have to have city populate two
drop downs called Street and Intersecting Street.