too many tables for relationships

[kevinrea]

hi guys,

i have a form that has a main form, and several sub forms..

the main form is one table and the subforms are each a table of their own.

when i tried to setup 1 to many relationships between the main table and all the sub tables., access 2003 said too many relationships..

anyway around this ?

i have about 65 sub tables that the main table relates to.

thanks,
kevin

 

[Lister]

I always thought that there could be a limit to the number of relationships a table could hold, just never new what number that was.

The number of links can sometimes be alot, but don't use redundant informatoin.

Without seeing the db it dose seem like a lot of links. Do you need all of them?
Copy the database and use the Tools/Analyse control to see if it can see any redundant use of links and information replication.

Also, build your forms from queries not off the tables themselves. They will run faster and you can cerate sub-links form table to table, without overloading that tables themselves.

See how you get on.

 

[Len Boorman]

Now I am not saying that there is anything wrong but

65 tables relating to the main table sounds a lot.

Are you sure that you have correctly normalised the tables.

I have had 60 tables in a database myself but there was nowhere near that number of relationships to a single table.

Suggest you critically examine the tables.

Normally the problem is that the design has not been normalised correctly and there are too few tables. This could be an opposite problem

Len B