Ok let me start from the top:
10 tables -
What I have is 2 different primary keys - these 2 keys contain the exact
same data throughout the various tables.
Table layouts:
The only part of the tables that are similar are the primary keys field.
The rest of the tables contain different field names.
I apologise if I explained this incorrectly or incoherently before.
Ok... it sounds like you have one to one relationships between the tables.
One to one relationships are QUITE rare. If you're not "Subclassing" or using
"field level security" it's quite possible that your relationships are
incorrect.
Also, a table cannot have "two primary keys" - only one. That Key can consist
of one field, or two fields, or ten fields - but it's only one primary key.
Could you explain what real-world Entity - person, place, or thing - is
represented by a few of these tables? What information are you storing about
the entity? If all ten tables have the same primary key, why use ten tables
rather than one table (which can be queried for subsets of the data)?
John W. Vinson [MVP]