I am receiving a runtime error (3314) when saving a new record to an Access 97 DB: “The field “Titles.ISBN” cant contain a null value because the required property for this field is set to true”.
The ISBN field is the PK of the Titles table and a FK in the AuthorISBN table.
The relationship between the tables is 1(Titles) to many(AuthorISBN).
Both recordsets have been .AddNew and the error occurs at the .Update for the recordsets, when i select cmdSave.
