Populating a drop down box

[Gatorajc]

Is it possible, using ASP, after populating one drop down box from a DB, to take the value that was selected to populate another drop down box from a DB based upon the value that was selected.

I have done this using frames and two seperate pages but I want to keep it on one page.

 

[rollo58]

I would just submit the selection to the same page and have the selected choice determine the second drop down list...or are you trying to make this happen without submitting? I wouldn't think that was possible, as the server has to be queried 2 seperate times.

 

[andrewbadera]

To avoid submitting the form and hitting server-side, your best bet is to build multiple JavaScript arrays, rendered using ASP on page load, representing your parent-child values, and populate your drop-downs based on the parent values and child arrays.