Create drop down menu for database?

I have a database of bands and concerts, and was wondering if I could
have a drop down menu with the band names, and when one was selected,
have the database display just concerts of that band. How would I do
that?

Thanks

Thanks, but I don't want to pay 50 bucks for something like that. I
just need to figure out a way to do this: When a band is selected in
the drop down list, all the variables in the table from the database
are changed to those of the particular band. Is this what this
extension does? How can I do this with code or Dreamweaver options?

Thanks

hieu (AT) webassist (DOT) com (Hieu) wrote in message news:<b19eae41.0307171025.1d4c3b47 (AT) posting (DOT) google.com>...

WA Dynamic Dropdowns is a commercial Dreamweaver extension that
ensures that your customers will find what they're looking for, fast.
It is perfect for your scenario where there is a parent recordset (the
bands) and a child recordset (the concerts associated with each band)
that is filtered with the parent. There are also client side behaviors
included with the extension that allow you to create functionality to
manipulate the dropdown lists as well as add/delete/modify selections.

Check it out at http://www.webassist.com/Products/ProductDetails.asp?PID=1

For more info, you can also watch free tutorial movies at
http://www.webassist.com/Products/ProductTutorials.asp?PID=1

Hope this helps,

--Hieu

Top Features:
Dynamically builds your options for your drop-down lists
Eliminates painful, time-consuming hand-coding
Makes it easy for customers to find what they want, fast
Queries don't hit the server ? so it won't bog down your users

Link: http://www.webassist.com/Products/ProductDetails.asp?PID=1

Price: $49.99

mgoodman63 (AT) hotmail (DOT) com (Mike) wrote in message news:<d6c50584.0307151147.6ea761c1 (AT) posting (DOT) google.com>...
I have a database of bands and concerts, and was wondering if I could
have a drop down menu with the band names, and when one was selected,
have the database display just concerts of that band. How would I do
that?

Thanks