Limit relationships for a field

  • Thread starter Thread starter Jackson Romero
  • Start date Start date
J

Jackson Romero

I have a bd in Access 2003 with 136 tables.
From a table (principal registries) it relation for many tables. This
relations is 1 to 1 or 1 to many.
This principal table has only an indice in PrimaryKey. But when I tried make
another relationship with integrity, fail and show message that has many
indices in the table.
What is number limit for this relationships with a table?
 
A table can have only 32 contraints. Each
relationship-with-relational-integrity uses one of those, and so does each
index.

If you have 136 tables, including lots of 1-1 relationships, there's a
pretty good chance that it is not normalized. The best solution will be to
read up on normalization.

We don't know what data you are trying to manage, but there may be a way to
reorganize the structure.
 
Back
Top