Too many indices

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

I have a primary table with an indexed field. Many of my
other tables are related to this table via the indexed
field. When I try to create another table relationship to
this index, I now get the error message "Too many
indices...".
I thought I could just create another table with that
same index ID number, make a one-to-one relationship to
the primary table, then use it for the other table
relationships.
But, if I do that, then try to change data on the
original it does not properly cascasde.
Any ideas?
Thanks
 
Are any of your tables using "lookup fields" at the table level? This is
frequently the case when this messsage pops up, as they create an index you
may not be aware of.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
 
I do not think so.
I read that the maximum number of indexes is 32. I am
probably at the maximum. Is there a way to create
a 'ghost' table (one-to-one) that has the same index that
will allow more relationships?
 
I am not using any lookup fields.
I think I am at the maximum of 32 indexes for one table.
Is it possible to create a 'ghost' table (one-to-one with
the primary table) that has the same key index, but will
now allow more relationships to it?
Did I explain that OK?

Table1 has fields:
IDnumber (used as index for 32 table relationships)
field1
field2
field3

GhostTable has fields
IDnumber (can be used for additional relationships)

But then cascade does not work well.
 
Back
Top