I am sure this is an obvious one, but for some reason everything I try is not working.
I have an Access front-end with a SQL back-end connected via ODBC.
I have a form with multiple sub-forms.
When I add a new parent record one of the related tables throws:
ODBC--call failed. Cannot insert the value NULL into column 'link to parent' column does not allow nulls. Insert fails. (#515) The statement has been terminated. (#3621)
The parent table has a RecordID (PK, int, not null) as a key. The related table (bound to the subform) has a RecordIDLink (PK, FK, int, not null)
I had what I thought were correct database diagrams where I set it for Cascading events, etc.
When this error started popping up I deleted the diagrams and reconnected to the linked tables. I even tried to use an append query to add the related record as soon as I go to a new record and that is still throwing the error.