Changing one drop down menu based on a selection in another.

[monkeymagic2222]

Hi,

Is there an easy way I can change the items shown in a dropdown list by clicking on another dropdown list. i.e. Category then Sub Category. Both drop downs need to be created dynamically from tables in a sql db.

I have trawled through various internet articles but the only real relevant items I can find involve using javascript "onchange" code when an item has been selected then posting the page back to itself and requerying the second table using a querystring. If I use this method I will lose all the other data a user has entered on that page.

 

[FesterSXS]

Take a look at Tarwn's FAQ on this subject - faq333-3656

Tony
________________________________________________________________________________

http://www.SpiraxSarco.com