Can you post this Emp_Mangmnt.mdb to experiment with?

BTW, I think emp_ID should be the one transferred to Table 2 instead of Empname.

Jimmy