The message you indicated is the last I mentioned where your referential integrity is preventing you from adding a record. I think you discovered that the reason this doesn't work was that you hadn't properly linked the subform using the Master/Child Link Fields. When you tried to enter data, in the subform, it didn't know which employee you were trying to add it to. In fact, it was likely trying to add it to a Null Employee ID.
So just set up your Master/Child Link Field properties correctly.
By the way, you don't have to create a field for the ID field. As long as the ID field is in the Record Source for the form, it will work.
Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org