Limit for relationships from a field

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 index in PrimaryKey. But when I tried make
another relationship with integrity, fail and show message that has many
indexes in the table.
What is number limit for this relationships with a table?

From ACCESS Help (search on Specifications):

Number of indexes in a table 32
Number of fields in an index 10


Note that ACCESS creates some indices under the covers -- when you create
relationships, for example, or when you name a field ID -- in addition to
the ones that you create on your own. If you open the Index window in your
table's design view, you may find some duplicate indices there.

--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/



"Jackson Romero" wrote in message
...
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 index in PrimaryKey. But when I tried
make
another relationship with integrity, fail and show message that has many
indexes in the table.
What is number limit for this relationships with a table?

Answered in microsoft.public.access.queries