Hello!

I would like to know how to create a drop down list where you can select one option from it, and the information chosen is then taken out of the drop down list completely, but the rest of the options remain.

We currently have 3 tables, which will collect the information to go into the drop down list, so its just literally just finding a way to take one option but leave the rest.

Although slightly vague, I hope this information is useful in some way, as it's all I have been given to work with. Any help would be much appreciated!
Thank you

this is not a mysql question

what language are you using to receive form input from the web page? php?

This is very possible but at a programming level. MySQL does not create dropdowns. Your application creates the dropdowns based on the data returned from queries in the database.

This is what were doing (sorry for any confusion) or at least trying to do...

..and without knowing which appliciation language you are using I doubt anyone can give you an answer

theres two separate but realted elements
theres the stuff relating to the design of the db and subsequent data manipulation (interacting with the database almost certainly via SQL)
and there's the front end the user interface. so faqr we are guessing you are using MySQL as your data storage and manipulation bit and that uses SQL. but as to your front end, who knows