Relationships

A

Argovian

I get the error "The operation failed. There are too many indexes on
tblReports. Delete some indexes on the table and try operation again" when
trying to create a relationship between two tables. There ae 20 tables in
total. What does this mean?
 
J

James Goodman

It means exactly what it says. You can only create 32 indexes per table in AccessXP (I think it varies with versions).

Create another related table, & continue creating relationships from this table...
e.g.
If a customers table has 32 indexes already, create a Customers_Indexes table, using the Customers.CustomerID key as the PK. You can then create another 31 FK relationships.

N.B. You may have to move a FK relationship field from the Customers table to the Customers_Indexes table in order to create the relationship between Customers & Customers_Indexes...
 
Top