Query and multi select

Hey guys, I have a problem that I can not seem to figure out. I have devolped a web app that allows our supervisors to input employee productvity into a database. It is actually working quite well but I want to add a feature to help eleminate errors.

The page I am having a problem with has 2 drop down boxes (AOR and Description ) that gets data from the database and 2 text boxes ( units and hours ) that the user inputs himself. It inserts fine and everything but what I need it to do is, once they select the AOR dropdown it then populates the decsription dropdown with all the items that match the AOR.

So lets say the supervisor picks 8989 in aor, i then want all the descriptions to that are associated with 8989 to be an option in the description drop down. It has to take place on the same page.

I hope this isnt to confusing, I can post the code I have tried if that helps.


Kevin

You'll either need to reload the page to populate the second drop-down box, or use Javascript to dynamically place elements into the second box in response to selections made in the first box. There are many, many scripts on the net for doing this. Or you can try the QForms Javascript API at http://www.pengoworks.com

Ok thanks for the help, I checked out the qforms and I found one that I like but I have no idea how to modify it to make it work for my situation ( not a programmer in any sense of the word ). I will try searching the net some more to see if I can find some other scripts.


Thanks,

Kevin

There are a number of custom tags and functions in the Macromedia ColdFusion Exchange that will do this as well. If you are not a programmer I'd say you have very little chance of hacking something out in raw code, you're better off using a custom tag that already exists. I searched for "select boxes" and got about 33 results in the CF Exchange. Hope that helps.