CODEWITHSUNDEEP
sqldatabasems-access
Braian Pita
Braian Pita

Reputation: 188

How can I avoid duplicates accross multiple columns in access?

My question is pretty simple, yet I am unable to find the answer I need. I have an access database with a table called coaches. I have another table called teams, which can have a coach and assistant coach. I need to be able to allow no duplicates across the "Coach" and "Assistant Coach" Fields. Coaches can be both head coaches or assistant coaches, so I cannot have a coach be both for different teams.

Upvotes: 0

Views: 79

Answers (1)

Gordon Linoff
Gordon Linoff

Reputation: 1270463

If a coach can only be assigned to one role for one team, then add the team and role to the coaches table.

This will guarantee that a coach can only be associated with a single team in a single role.

Upvotes: 1

Related Questions