Relationship Limit, workaround or redesign?

[neo651]

I have a database of devices with 27 different tables. Scattered amongst these tables are fields like "Device Type" "Configuration Type" "Device Status" "Location Type". A while back I decided to consolidate all of these kinds of fields and name them "Parameters".

There are 2 tables. tblParameterType and tblParameters. Currently there are 17 parameter types and 93 parameters. The purpose is to simplify the process of adding these types of fields to tables and to simplify the process of populating combo boxes in the forms for these tables. So far it's been working fantastic. The problem now is that some of my tables have upwards of 3 relationships to tblParameters and today I ran into/found out about the 32 index limit in Access.

Is there any way around this, keeping in mind that because of the purpose of the design there will always be more relationships being made with tblParameters?

If there is no way around it, what is a good redesign strategy that doesn't involve making 17 new tables for all existing parameter types and then subsequently making a new table each time a new parameter type needs to be made?

[June7]

I am not following relationship description, probably bad design, could you provide the project for analysis?

[Access_Blaster]

I don't think you can get around the 32 index limit in Access.
When you bump up against these limits it's a good indication you may have a flaw in your design.

http://office.microsoft.com/en-us/ac...462.aspx?CTT=1
http://office.microsoft.com/en-us/access-help/access-2007-specifications-HA010030739.aspx#_Toc272158326