Error message 3341 - field must match the join key

[Jim]

I have a form which is based on a join query. The join relationship is one
to many. When a new record is added and the user enters a value for one of
the fields in the "many" records, I attempt to lookup (using DLOOKUP) the
parent record and set the join field in the subordinate record to the key
for the parent record. However, when I do this I receive the error "3341 -
The current field must match the join key <field> in the table that serves
as the 'one' side of one-to-many relationship. Enter a record in the 'one'
side table with the desired key value, and then make the entry with the
desired join key in the 'many-only' table."

Any suggestions as to how to do what they are suggesting? What I need to do
is bring up the "many" side of the form and then enter a new record on the
"one" side of the form.

Thanks in advance

[pietlinden]

Jim wrote:

I have a form which is based on a join query. The join relationship is one to many. When a new record is added and the user enters a value for one of the fields in the "many" records, I attempt to lookup (using DLOOKUP) the parent record and set the join field in the subordinate record to the key for the parent record. However, when I do this I receive the error "3341 - The current field must match the join key <field> in the table that serves as the 'one' side of one-to-many relationship. Enter a record in the 'one' side table with the desired key value, and then make the entry with the desired join key in the 'many-only' table."

Any suggestions as to how to do what they are suggesting? What I need to do is bring up the "many" side of the form and then enter a new record on the "one" side of the form.

Thanks in advance

How about creating a "one-to-many" form the easy way? Create your
"many" form. Create a relationship between your "one" table and your
"many" table in the relationships window. Enforce referential
integrity. then create a subform based on the child table. Open main
form in design view and drop subform into it. Then open the form and
use it. What could be easier than that?
Oh, you want to be able to go to some specified record? Umm... that's
what the unbound combobox wizard is for...