New row to two related tables with one form (1 Viewer)

[2wistd]

So I have a form, it has a few fields from a related table in it, related by the name. I click 'new' on the form, but when I click save Access complains about the related table does not have a matching record. How do I have it create a new record?

 

[Cronk]

Post the SQL for the form's data source.

Are New and Save buttons on the form?

 

[Pat Hartman]

You will get this error message if you have an optional foreign key and the table has a default value of 0. The default for foreign keys should always be null. If the FK is required, set the required property to true.