View Single Post
  #1  
Old February 20th, 2010, 12:54 PM posted to microsoft.public.access.tablesdbdesign
Loterken
external usenet poster
 
Posts: 12
Default 1 to 5 relationship

I have 2 tables
table "Person" and table "Team" with a 1-M relationship
a person can be a member of 0 or 1 team
but a team can have from 0 to 5 Persons
at the moment i am enforcing this with code
is there any way to enforce this with a constraint on table "Team" ?