[talax]

Hi,

I have a situation where someone types in their employee ID, and I would like to then populate a drop down box based on that employee ID. The choices for the dropdown box are in a SQL table, and I would have another SQL table that lists what options from that dropdown box are available for that employee ID. I am using ASP (not asp.net) and either javascript or vbscript.

For example:

The dropdown box has the following choices:
resource1
resource2
resource3
resource4

if someone types in employee ID 1234, I would do a lookup to find out what options employee ID 1234 has, show that they have access to resource2 and resource3, then the dropdown box changes to:
resource2
resource3

or if someone types employee ID 2345, then the dropdown box changes to:
resource1
resource4


Is this possible?

[TwoD]

The easiest way to do this is to reload the asp page and simply let asp populate the list. Handeling the response from SQL is a bit trickier, I have not done this myself since I don't code asp but I have heard of those that have. How are you sending the data from the SQL query back to the browser?