I would like to know which direction would be the easiest. I want to use multiple dropdown lists to assign operators to different machines for each shift. I have a SQL list that I can query with all the operators and their usual shifts. When you select one data in a multiple dropdown list, it is no longer available, which is great. I would like to show only the operators that have not been selected on other machines in all the dropdown lists.
For example, if Machine_1 has Alex working on it, when I open the dropdown for Machine_2, Alex should not be available anymore.
I thought of using a WHERE clause in my SQL query to exclude all operators that are selected in the other dropdown lists, but that would mean I would have to create 50 inputs for each dropdown. So, I would like to know if someone knows an easier way i just started so you think i should change my structure let me know.