Sorting with a menu
I need to know if it's possible to have a "drop-down" menu with a bunch of values, when one is selected a table shows up displaying just those values. I have a list of bands in a database and would like a user to be able to select a band name and just show the shows for that one band.
Comments
filter on menu list
If you create two menu lists, the first one with your band list, the second with a recordset of all shows, filtered on either a form or url parameter.
The first menu should be inside a form which is targeted at the same page.
The second menu is outside this form, and has a Show if True statement so it only shows when the passed varible exists in its recordset.
When you submit the first menu, the second menu will appear with just the lists for that band etc.
If you wish you can use a Jump menu, but that requires some hand coding, and my experience in Dreamweaver has been negative using the jump menu for this in v6+
Hope this helps
You must me logged in to write a comment.