ACC: Cannot Create 1:1 Relationship Without Unique Index (141106)
The information in this article applies to:
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q141106 Novice: Requires knowledge of the user interface on single-user computers.
SYMPTOMS
When you try to create a one-to-one relationship between two tables and
enforce referential integrity, the one-to-one relationship type is not
available in the Relationships dialog box.
CAUSE
The "foreign key" table does not have a unique index. In Microsoft Access
97 and 7.0, the Microsoft Jet database engine requires that you create a
unique index on the foreign key table before creating a one-to-one
relationship that enforces referential integrity. However, in Microsoft
Access version 2.0, the Microsoft Jet database engine automatically creates
a unique index on the "foreign key-side" if one was not already defined.
RESOLUTION
Add a unique index to the foreign key table, and then create the one-to-one
relationship.
REFERENCES
For more information about creating relationships, search the Help Index
for "relationships," or ask the Microsoft Access 97 Office Assistant.
Modification Type: | Major | Last Reviewed: | 10/20/2003 |
---|
Keywords: | kbprb KB141106 |
---|
|