ACC: AutoLookup Query Not Performed with 1-to-1 Relationship (121332)
The information in this article applies to:
- Microsoft Access 2.0
- Microsoft Access for Windows 95 7.0
- Microsoft Access 97
This article was previously published under Q121332
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
Microsoft Access will not perform an AutoLookup query if it determines that
the tables in the query have a one-to-one relationship.
CAUSE
Microsoft Access determines the relationship between the tables in the
query by examining the indexes on the join fields. Microsoft Access will
ignore the relationship that you specify when it is determining whether to
perform an AutoLookup query. If your tables have one of the following
index combinations, Microsoft Access will not perform an AutoLookup query:
Table 1 Table 2
---------------------- ----------------------
Primary Key Primary Key
Primary Key Indexed, No Duplicates
Indexed, No Duplicates Primary Key
RESOLUTION
To cause Microsoft Access to perform an AutoLookup query, make sure
that the foreign key is neither indexed as the Primary Key nor Indexed, No
Duplicates. It may be necessary to add a unique index to the foreign key on
the "many" side of a relationship in order to maintain the integrity of the
data. In this case, AutoLookup will not work and a workaround will have to
be used.
REFERENCES
For more information about AutoLookup queries, search the Help Index
for "AutoLookup queries," or ask the Microsoft Access 97 Office
Assistant.
Modification Type: | Major | Last Reviewed: | 5/6/2003 |
---|
Keywords: | kbprb KB121332 |
---|
|