Synchronized combo boxes...

  • Thread starter Form to review and update records, cmbos
  • Start date
F

Form to review and update records, cmbos

I am trying to use synchronized combo boxes to review records in a table and
then also to add records to the end of the table, but run into an error
#3341 "The current field must match the join key in the table that serves as
the one side of a one to many relationship." Not sure why I am getting this.
Help please.
Bill Arthur
 
H

Hermawih

Please check your tables .

I can best explain it using my own imaginary siatuation.
I have a table named tblOne : IDone - long Integer
I have a table named tblTwo: IDtwo - Integer .

Putting IDtwo value on IDone will create the problem because of different
data type . (Err# 3341)
Hope that helps.
 
F

Form to review and update records, cmbos

Thanks but did not help, as all my ID numbers are long integer. Let me
explain more. In simple database I have 3 tables, Owner, Autos, and Repairs,
each relationship is one to many (one owner can have many autos, one auto
many repairs...). The repairs form is used to review repairs and add new
ones. In it, Cmbo1 determines ownerID, and Cmbo2 queries Autos table for
autos owned by OwnerID and I choose AutoID. This form works fine in
reviewing past repairs, but fails when I go to update. As soon as I click on
the auto, I get this error message. Both combos are bound. Thanks for any
help.
 
Top