Exclude previous selection from Combo

[Fizzio]

How do you exclude a selection from a combo that has previously been selected in another combo? I am Creating a Soccer Db and using Combo's to select the team but each player can only have 1 position!. I have thought about using a separate query for eack combo, excluding all the other combo selections, but I have 18 on the form and was looking for a more generic way.

If Mike Gurman is out there, I saw you managed it here http://www.access-programmers.co.uk/ubb/Forum4/HTML/004320.html
but there are no clues (I do not know what a Cartesian Query is)

 

[ColinEssex]

Hi Fiz

I'm interested as to how your soccer database fits into the daily running of a Physiotherapy dept ! Is this some new kind of activity for patients - Physio v XRay maybe?

Col

 

[Fizzio]

It's for my Bro but now that you mention it, I'll pass that onto my boss as a future service development. We could have patient groups in a patient World Cup. Amputees vs Joint Replacements = Hops vs Hips. Spinal patients vs COAD (with sputum++) = Backs vs Hacks. etc etc (Unless you can come up with better)
But.... does this solve my problem!!!