I didn't say that your structure was incorrect but that I've seen in the
past the multi-step updating feature of Access having trouble with updating
some kind schemas.

Are you sure that when you make an insert in the table tblEmploye, new
records don't get created into one of the other tables such as
tblBenefitType, tblCompany or tblCorporation? Is it possible that the rogue
ID could come from one of these three other tables?

Also, I took a second look at your original post and you say that the table
tblEmploye is the subform and the table tblCompany the main form. However,
in your requests, you are extracting the fields of the associated table
tblCompany with a Left Outer Join. I don't see the usefulness of this as
only one associated company can be displayed at the same time in the main
form. In fact, I don't understand at all the use of a Left Outer Join here
instead of a regular Inner Join.

From your first and third exemple, Access seems to make a difference between
« SELECT C.*, BT.*, E.* » and « SELECT * ». What happens if you write down
explicitely all the fields?

Finally, which version of Access are you using? I hope it's not A2000.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF


"Pete Nurse" wrote in message
ups.com...
No, the relationships are all 1-many - I don't use 1-1. 12 years of
experience designing databases makes me pretty sure the structure is
correct.