Dynamic Menu

[24680]

I am trying to put together a form that pulls information out of a table called properties in the db. Then I am trying to add 2 more colums at the end of the table with drop downs. The first drop down is category and the second is sub_category. The point is that when you pick a category only the relative sub_categories will show up. Category and sub category are in separate tables with a common column cat_id. On submit it should populate a new table with all the info. I can get the list but I am having proplems with the drop downs.
[sig][/sig]

 

[giahan]

Hi,

You need somehow activate the dropdown menu of your list (meaning whenever you select the uplevel Category, the sublevel category changes). You can use onClick to do that

I hope it helps
[sig]<p>GH<br>[/sig]

 

[PetersWeb]

I've used some javascript code I found at

http://javascript.internet.com

to do exactly what you're asking!.

It's called &quot;Country Chooser&quot;. I've adapted it to run Cold Fusion queries to populate the select boxes and it works a treat!

Hope this helps.
[sig]<p>Peter Toby<br><a href=mailto:webmaster@petertoby.com.au>webmaster@petertoby.com.au</a><br><a href=

http://www.petertoby.com.au>PetersWeb</a><br>My

site is under construction but getting better![/sig]