I have seen a few threads about this question. Just wondering if anyone has come up with a workaround.
Suppose I have a People sheet and a Teams sheet. And a person is joined to a team using a Memberships sheet (with a person_id column and a team_id column). How can I ensure that a person can only have one membership for a given team? Or, to say it another way, how can I ensure that every row in the memberships sheet is unique?
Or maybe there’s a way in the UI to show only Teams for which the current Person does not have a Membership? Like a “not” relation between People and Teams?
Any ideas or suggestions are greatly appreciated.