dropdown menus

[cygnusdeneb]

Hello,
I am relatively new to asp programming and am having an issue with a database retrieval system. The page is at

http://www.otechimg.com/diccon/diccon.asp.

; The issue has to do with dropdown boxes for choices in doing a db search. At this point, a user must select a modality (ie printer, ultrasound, workstation, etc) and then select from a list of ALL vendor name and version of the products. I would like to be able to select the modality in the top dropdown, and then have only the vendor name and versions of those specific modalities show up in the second dropdown. IE if I choose printers, in the modality dropdown, then only vendor name and version of all printers in the database would show up in in the second dropdown. Then, after the selection is made in the vendor name and version dropdown, I would like for the displayed results to remain as they are currently. I'd very much appreciate any help that could be offered. Thanks and have a great day!

 

[dianal]

Hello,
Try this link

http://www.asp101.com/resources/DependentLists.asp

See how the example works and if it as your intendent use, you could figure out from explanation how to use the code.
Hope this helps.
D.