Article ID: 208353 - View products that this article applies to.
This article was previously published under Q208353
This article has been archived. It is offered "as is" and will no longer be updated.
Novice: Requires knowledge of the user interface on single-user computers.
When you try to create a relationship that enforces referential integrity, and the relationship involves a multiple-field primary key, you may receive the following error:
No unique index found for referenced field of primary table.
The order of the primary key fields in Design view of the table is different from the order of the fields in the PrimaryKey index.
There are two ways to work around this error:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Steps to Reproduce Problem
Creating the Tables
Creating the Relationships
For additional information about using a multiple field primary key, click the article number below to view the article in the Microsoft Knowledge Base:
209564For more information about referential integrity, click Microsoft Access Help on the Help menu, type What is Referential Integrity in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
(https://support.microsoft.com/kb/209564/EN-US/ )CC2000: Compound Indexes Must Restrict First Indexed Field