For some reason when I add records to a subform the master field ID from the parent form does not transfer to the subform and add it to the table?
Main form PK: EmployeeID
Subform FK: EmployeeID
After I add events on the subform, the FK doesn't populate at all and when you go back to the record the items you have entered are gone. When you check the table, the entries are there, just missing the EmployeeID field?
I know it's something simple that I am overlooking, any help is greatly appreciated. Thanks.
On the subform, Link Master Fields and Link Child Fields are both set to EmployeeID.