how do i populate a second drop down menu based on the what the user has chosen on the first drop down menu?

i have two tables wherein one of the column in the one of the tables is a foreign key to the other. pls advise. thanks.

Hello,

I say you add a blank option for the first dropdown:

<option value=""></option>
You do this because the user will have to choose a value from the list. Here you add a function for onChange event by calling the same page with a parameter. The second dropdown will display all values in a recodset only if the parameter is present in URL.



-----------------------
Cirstoiu Aurel Sorin
InterAKT Support
www.interakt.ro
-----------------------