You Cannot Add or Change a Record

[scubasteveku]

I am trying to input data into a database I created for work and keep getting an error message that states "You cannot add or change a record because a related record is required in table 'Resident'." I have attached a copy of the database with all personal data masked. I have looked at the relationships and cannot figure out what I am doing wrong. If someone could help, I would appreciate it. Thank you.

[June7]

You have Tasks and Residents tables linked on the autonumber primary key fields. Cannot link on two autonumber fields. This is meaningless. Each number is generated independent of the other.

ID in Residents should link to Apartment # in Tasks.

Advise no spaces or special characters/punctuation (underscore is exception) in naming convention. Better would be ApartmentNum or Apartment_Num.