Form to review and add records, using cascading combos

[Form to review and update records, cmbos]

In my simple database there are three tables: owners, autos, and repairs, in
which each owner can have multiple autos, and each auto can have multiple
repairs. I want my repairs form to review past repairs data in the repairs
table and accept new data into that table. In combo1 I choose the owner, and
in combo2 I choose the auto after querying the autos table for criteria
ownerID = combo1 selection, hence only shows autos owned by ownerID. It
works fine in reviewing data, but when I go to add a new record, I get the
following message:

The current field must match the join key <name> in the table that serves as
the 'one' side of one-to-many relationship. (Error 3341).

The one side of the one to many relationship is the AutoID value. Can
anyone tell me why this is not working?

Thanks,
Bill Arthur

 

[Klatuu]

I think maybe there is some confusion here. In this case, the one side is
the OwnerID. Are you using the Not In List event of the combo box, or are
you in the subform trying to add a record?

 

[Form to review and update records, cmbos]

OwnerID is the one side of the Owner - Autos relationship, and AutoID is the
one side of the Autos-Repairs relationship. I am not using the "Not in LIst"
event, and am not using a subform. Just trying to add a record to the
Repairs table by designating Owner and Auto in the combo boxes, and adding
repair information. This seems like such a simple everyday thing that any
database would allow, but I seem to be struggling so with this. I still do
not know the answer.
Thanks for your help.