Dynamic drop down list

[Gragi]

Hello,
I have a table in SQL Server like
Col A - Col B
Software - Microsoft Office
Software - Dreamweaver
Software - SQL Server 2005
Hardware - Laptops
Hardware - Monitors
Hardware - USBKeys

So here I'm writing some SQLs in ASP code to get these 'Col A' and 'Col B' into 2 different drop down list boxes and works fine like 1st drop down gets Software, Hardware as items, and in the 2nd drop down get all items from the 'Col B'.

Here my requirement is when I select Software in the first drop down 2nd drop down should display only 'Microsoft Office', 'Dreamweaver', 'SQL Server 2005',
and when I select Hardware in the 1st drop down 2nd drop down should display only 'Laptops', 'Monitors', 'USBKeys'

Please I need urgent help on this...
I really appreciate your time..

Thank You,
Gragi

 

[Sheco]

You could modify your SQL query so that it uses a WHERE clause...

Or perhaps use your ASP to write some client-side javascript array and then use add/remove itesm from your dropdowns using client-side programming.

 

[Gragi]

Thank You Sheco for your response, meanwhile I found very good links to my problem..

http://tek-tips.com/faqs.cfm?fid=1507

Gragi