"Cannot add records; join key not in record set" ?

[Koggala]

Creating my first DB.
Created a 5 table DB, analysed by the wizard and it has no suggestions to improve. (I guess my relationships are all OK).
BUT...
Creating the forms for data input, when testing i get the dreaded musical "Dunk" when i try to input data in my 3rd field.
Field 1 is auto number from "projects" table, Field 2 is a text field from Projects table. Field 3 is a text field from "Contacts" table. one project can have many contacts and is set up so.

ray:

Any help is fantastic

John

 

[bat17]

Make sure that in the query behind the form you have the key fields from each table in the query grid, even if you dont use them in the form.

HTH

Peter