One to Many

  • Thread starter Thread starter Steve Walker
  • Start date Start date
S

Steve Walker

Is there a limit to the number of one to many relationships on a PK in a
table. I am using Access 2000 and need to use several junction boxes for
many to many relationships.

Steve
 
A table can have a maximum of 32 indexes, and I believe Access creates an
index for each relationship. Since some of the indexes may not be part of a
relationship, you won't necessarily be able to have 32 relationships.
 
Thanks Douglas
Steve

Douglas J. Steele said:
A table can have a maximum of 32 indexes, and I believe Access creates an
index for each relationship. Since some of the indexes may not be part of a
relationship, you won't necessarily be able to have 32 relationships.
Click to expand...
 
Back
Top