Need your advice

[As226]

Hello forum
I come to seek your advice for the links of the tables of my data base. I have a synthesis table with the Mle field as the primary key. And the other tables have a field combination that is used as the primary key, including the Mle field. I would like to link all my tables to the synthesis table. What advice do you give me to optimize my data base?
Nb: I have 40 tables to link to the synthesis table. And there is the limit of the indexes. How can I proceed? Thank you in advance for your advice.

[ranman256]

It seems you only need 1 formation table,not 40.
add a field to make the distinction, like [Version].

[As226]

Hi ranman
It's just a exemple to show the problem. On real data base, i can't reduce the number of tables

[ranman256]

That makes no sense. You can run a make table query and consolidate.

[CJ_London]

What advice do you give me to optimize my data base?

At first glance you appear to be applying Excel methodology to a database. As Ranman suggests, combine the 40 tables into 1 and include an additional field to indicate whatever the reason for the 40 tables.

Other suggestions, include a proper PK for the table (autonumber) and include a multi field index for your 3 fields with the allow duplicates constraint set to No.

Otherwise you need to provide more information.

[phivosz]

It seems you only need 1 formation table,not 40.add a field to make the distinction, like [Version].

Agree with the above.Also "Need your advice" is not helpful as a thread title. I mean, everyone here needs advice. Try to give a title that gives an idea of the topic.

[orange]

Further to other responses you have received, your post is confusing in that it lacks details and your structure seems redundant/not normalized. It would be helpful to readers and to you if you could provide a simple description of your business and a few examples of formulations and synthesis.
When you say

It's just a exemple to show the problem

and readers find it confusing, then perhaps it isn't the best example to highlight/communicate the real requirement.
Good luck with your project.