Drop-Down List Help?

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 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 🙂