How to filter data in a drop down based on selection in other dropdown

[Kingkumar]

Hi,
I am new to asp so please excuse my silly questions.

I need to have 3 drop downs on my asp page and the data in the drop down should be filtered based on the selection in the above drop down.
eg. Until user selects something from dropdown 1 nothing should be displayed in drop down 2& 3
and based on selection in 1 data in 2 should be filtered out and similary based on 1 & 2 the data in 3 should be displayed.

so the questio i have is IS IT possible to do in asp?
if yes then can i do it one recordset or i have to have three different ( i mean based on fist selection the database is accessed again and so forth.)

Thanks for your help

--King

 

[SecondToNone]

it can be easily done using Javascript...check FAQ's on both ASP and Javascript forums...

look under the section Dynamic Linked Lists at

http://www.tek-tips.com/faq.cfm?pid=333

Here is a good one:

http://www.atgconsulting.com/triplelist.asp

-SecondToNone