By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,707 Members | 1,640 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,707 IT Pros & Developers. It's quick & easy.

Error message 3341 - field must match the join key

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

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...

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.