Dropdown determines results in next dropdown 1

[skicamel]

Not sure which forum to post this to, feel free to send me elsewhere if need be...

Is it possible, on one page, to have two dropdown boxes... the first drop down to choose a database, then the second dropdown would query that particular database for the values to populate it?

Ex.

Dropdown 1: database1 (value = Database1)
database2 (value = Database2)
database3 (value = Database3)

Dropdown 2: Staff Member (value = unique ID based on which database chosen in first dropdown)

I'd imagine there is some javascript or some similar On_____ type method to hold off querying until a db is selected... Just not sure where to go...

Don't mind doing my own homework, but any pointers would be appreciated.

Thanks again all.

 

[Ariadna]

You will need to add event onchange in your first dropdown1,
in this event onchange reload the page or submit the form, to pass value chosen in dropdown 1.
For forming dropdown 2 use this passed value of dropdown 1.

Main idea is that after changing value of dropdown 1 you will need to reload page and form dropdown 2 depending on passed value of dropdown 1.

 

[BB101]

Alternatively and probably not the best to do it for large volumns of data is to use a this piece of javascript

http://www.mattkruse.com/javascript/dynamicoptionlist/source.html

its perfect for what your saying and requires no page loading in between selections! --BB

 

[skicamel]

Thanks folks...Just what I needed.