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