Dynamic dropdown menus

[nejcpass]

Hi all!

I neead a little help from the Javascript experts.

I have offices and people in offices in 2 different drop down menus.
I'm trying to make people in offices menu dependend on the office selection.
I mean when I select an office only the people who are in tha offce apear in the other drop down menu.

Can anybody please help me out?

thanks in advance.

[Noddegamra]

Yes, don't use JavaScript. Use PHP, MYSQL and CSS to handle this situation.
Use PHP and MySQL to handle the users and usergroups. Also hold the menu in a seperate table. Upon user authentication, pull the relative information from the database and present the CSS-based dropdown menu.

[nejcpass]

thanks nodde.
Unfortunatelly I can't use php. that's the company limitation. Just javascript and coldfusion.
Coldfusion is not a problem but javaScript is causing me problems.

I have 2 sql's
1'st one to pull out all my offices and second one people in offices which I have limited by office.

[nejcpass]

Does anybody else have a suggestion?