I'm hoping this will probably be something someone can solve pretty quickly. I have the following tables/relationships that I am trying to base a form off of:
The form I am trying to make is one that displays the employee's name and location and then subform displaying their phone numbers and phone purpose (cell, work, etc). The forms work fairly well but when I try to add a phone number and purpose to an employee within the subform I receive the "Cannot add or update a record because a related record is required in table tblEmployee".
How do I get the subform to automatically inherit the EmployeeDBID when I am adding a new record?
My form looks like this:
I've also attached a zip file containing my db:
Stahly Project Database.zip
Thanks!