ACC: Error Entering or Editing Linking Field in Multitable Query (96587)
The information in this article applies to:
- Microsoft Access 1.0
- Microsoft Access 1.1
- Microsoft Access 2.0
This article was previously published under Q96587
Moderate: Requires basic macro, coding, and interoperability skills.
SYMPTOMS
When you add or edit records in a form or query datasheet and you attempt
to commit the record by moving from the current record or by closing the
recordset, you may receive the following error message:
Join is broken by value(s) in fields '<field name>' (in Microsoft
Access version 1.x)
-or-
There is no record in table '<table name>' with key matching field(s)
'<field name>' (in Microsoft Access version 2.0)
In the sample messages above, <field name> identifies the foreign key and
<table> identifies the one-side table.
CAUSE
You tried to enter or edit data through a query based on more than one
table. In a one-to-many relationship, you entered or edited data on the
"many" side, and a corresponding match based on the join field does not
exist on the "one" side.
STATUS
This behavior is by design.
RESOLUTION
When you add or edit records in a query, if the relationship between two
tables is a one-to-many relationship, only enter values in the linking
field in the "many" table that have matches in the linking field in the
"one" table.
Modification Type: | Major | Last Reviewed: | 5/9/2003 |
---|
Keywords: | kbprb kbusage KB96587 |
---|
|