Relationships

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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...
 
Back
Top