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
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
-------------------------------------------------
The more details you give, the easier it is to understand your question. Don't save the effort, tell us twice rather than not at all. The amount of info you give strongly influences the quality of answer, and also how fast you get it.