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?
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.