4 Dropdown boxes on form; Select player-will not show up in other 3 dropdown boxes

[henryihunter1954]

I have 4 dropdown boxes on this form.
There are 4 player names in the first box.
After selecting one of the players, the 2nd dropdown will only display (3) three players that were not chosen, etc.
Same with 3rd dropdown box - only 2 players will be diplayed.

Thanking you all for any suggestions.

 

[jdraw]

Not sure what your base question is, but I expect that Cascading Combo boxes may be part of the solution.

Older free videos -these are a clear illustration of the concepts involved
http://www.datapigtechnologies.com/flashfiles/combobox1.html
http://www.datapigtechnologies.com/flashfiles/combobox2.html

 

[henryihunter1954]

jdraw:

Thank you very much. I am learning sql now. I had been basically using Access interface to build. It's absolutely imperative to know sql now at this level.

Thanks for the info.
I also viewed the videos. Both taught me a few things that I did not know, especially in the modules.

This makes me feel that I'm learning from the best here on this forum.

Thanks again. Will use the suggestions and you all are really helpful and prompt too.

 

[henryihunter1954]

I tried it this morning. Works like a charm. Beautiful.

Thank you so very much for your suggestions, the videos, and the code.
I got a lot of information.

As I clicked on the second box, the only names that came up were the names that did not match my first combo box name. Great.
The same with box 3 and box 4. Only one name was left for box 4. That is what I wanted. This will not let the data entry person make the mistake of placing the same player in 2 different combo boxes. Exactly what I wanted.

Again, thank you very much Jdraw.