One to Many

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
 
D

Douglas J. Steele

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.
 
S

Steve Walker

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding data to MS Access from csv file 0
Multiple Many-to-Many relationships 10
Relational Database Join types 4
Need help with relationship???? 7
"Circular" Relationship 3
Junction Tables 2
Assistance with Many-to-Many Relationships 6
How to have two tables on same line? 1

Top