2 dependent dropdown box from mysql

[keikei]

How can I make a multiple list[combo] that would depend on the first multiple list[combo] box that is dynamically being populated from my mysql database

example:
I have 2 combo boxes one for department the next is for employee when the user selects which department the next combo box would automatically be populated from my mysql database with only the employees that has same department as the first selected dept box

I have already successfully done the first dropdown box but I have no clue how to do the second

[psycorpse]

This would take some javascript to make this happen. You might do a google search for dynamic drop down javascript or something like that.

Basically what you will do is populate your first box and then do a onChange="javascript:function(this)". In that function you would have populated the javascript with your emp information and it would have to set the fields in the second drop down.