Relationships Question....

J

John Vinson

What is the maximum amount of 1:M relationships that you
can have in a database?
Click to expand...

Any one table is limited to 32. I'm not aware of any database-wide
limit.
 
R

RSGinCA

What is the maximum amount of 1:M relationships that you
can have in a database?
Click to expand...

Any one table is limited to 32. I'm not aware of any database-wide
limit.
[/QUOTE]

Where does that 32 come from?

I see that a table has a limit of 32 indexes. Howevew, when a table is on the
'1' side of a 1-M relationship, there isn't an index for THAT table is there...
it would be associated with the table on the 'M' side of the relationship. So
a table could be on the '1' side of 100 1-M relationships but could still only
have a single index. Or am I wrong? (I've been wrong a lot lately!)

Rick
 
R

RSGinCA

What is the maximum amount of 1:M relationships that you
can have in a database?
Click to expand...

Any one table is limited to 32. I'm not aware of any database-wide
limit.
[/QUOTE]

Where does that 32 come from?

I see that a table has a limit of 32 indexes. Howevew, when a table is on
the
'1' side of a 1-M relationship, there isn't an index for THAT table is
there...
it would be associated with the table on the 'M' side of the relationship.
So
a table could be on the '1' side of 100 1-M relationships but could still
only
have a single index. Or am I wrong? (I've been wrong a lot lately!)

Rick
[/QUOTE]

Whoops... backwards (I told you I was wrong a lot lately...)

But, still the same logic applies... if you switch my '1' and 'M' around.

Rick
 
J

John Vinson

So
a table could be on the '1' side of 100 1-M relationships but could still only
have a single index. Or am I wrong? (I've been wrong a lot lately!)

Rick
Click to expand...

It may be me that's wrong: there's nothing in the Specifications help
that would indicate a limit. OTOH, that would be a very peculiar "sea
urchin" relationship diagram; but you're right, I don't see anything
that would specifically exclude it!
 

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

Can activities be imported with their relationships? 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Relationships 9
Mail Merge Switch - Dollars to Words 0
Relationship Help 3
1 to 5 relationship 6
Where should relationships be created? 8
Extra relationship 2

Top