I have 2 related tables, Company and employee. They have a one (company) to many (employee) relationship with a defined Company ID. I created a form I would like to use that has information from both tables. I have a combo field for company ID that when the ID is typed in auto populates the company information (on Change), with the intent of being able to add new employees easily. It works... except, I can't save anything. It errors anytime I try to add a new employee to the form. I assume it's trying to add a new record in the company table as well, which wont be allowed as the PK is that company number and can't be duplicated. But how do I fix this? I don't need to be able to add anything to the parent (company) table using this form but I can't figure out how to fix this.
I have a different database with a one to one relationship and this problem doesn't happen.