Too many indexes

[kaizenkk]

I received an error message that I had too many indexes on a table...32 is the max I guess. I believe this is referring to the number of relationships in the table. Is there a way around this that is not too complicated...I was trying to add a list of check boxes to the table.

 

[CBrighton]

It should be referring to the amount of fields in the table which have the index property set to yes (no duplicates) or yes (duplicates ok), or something similar.

 

[kaizenkk]

Yes, I have 24 fields that allow duplicate values....I thought I could have 32.

 

[CBrighton]

And how many which do not allow duplicates?

 

[kaizenkk]

Looks like 19 that have multiple drop down values but do not allow duplicates.

 

[CBrighton]

So you have 19 indexes which don't allow duplicates and 24 which do and you think the max is 32?

19 + 24 = 43

43 > 32

 

[Galaxiom]

You probably need to reconsider your data structure. That is quite a lot of fields in one table.

Can you describe your table structure, post a cut down sample of the database, or an image of the Relationships window?

 

[bparkinson]

You probably need to reconsider your data structure. That is quite a lot of fields in one table.

Can you describe your table structure, post a cut down sample of the database, or an image of the Relationships window?

Yes, this is likely the real issue. There are probably several business objects represented in his table.