I'm still pretty newbie in Access but I was given a project to edit our access database to input a new name into the database so that, that name can be used to fill out forms. After adding a new record (the new user) inside the table with the names, I get the error message "you cannot add or change a record because a related record is required in table access" when filling out the form with that name.
I have "enforce referential integrity" with both "cascade update related fields" and "cascade delete related records" checked. I assumed after having these checked, there shouldn't be any issues?
Any help is appreciated!!
To add-on, all of the other names in the table works fine when filling out the form, just the new name (record), doesn't work.