Equiv of Access cascading combo boxes with DW mx?
Is it possible (and if so, how?) to add something like the cascading combo boxes found within Access forms? Ie: two dropdown lists, one for State, the second for City. Once the state is selected, the results available within the City drop-down will be only the cities within the selected state? Seems like I should be able to use some type of query on this second list based upon results from selected entry in the first....
Any ideas? Thanks in advance!
Comments
Dynamic drop downs
this is formatted a bit better ;o)
You can create two drop down menus, driven from the database, using two recordsets, the second one filtered, on a variable passed from the first drop down menu.
You would make each menu separately, creating a form around each drop down.
The first drop down would point back at the same page, and pass a variable, that would filter the second menu's recordset.
Place a Show Region if Recordset is Not Empty around the second form so it only appears once you have made a selection from the first menu.
If you would like more details use my contact form, www.cgw3.co.uk/contactus/
Extension(s) available
Dynamic Dependent Drop Down Lists
Free extension
Dynamic Dependent Drop Down Lists
http://www.kermy.com/
You must me logged in to write a comment.