Exclusion Constraints in Access

[desmonda]

How can I implement an exclusion constraint. For my assignment, I am designing a sport database. If you play netball, you cannot play tennis or volleyball as they clash so you must choose only one. How can I go about this? I am clueless and any help would be appreciated

[ranman256]

In a query,Q1,Select all items for one sport.
In Q2, use Q1 and join on player, and create an OUTER join for those where sport =null.

this prevents a player from picking 2 sports.

[orange]

Is this not a continuation of this previous post?

As I mentioned there, it is always a good strategy to write down the big picture/entire business so as to get all the requirements identified in context.

People
Sports
Exclusions
Other Criteria

Good luck.