Data to another table

[Hanksor]

I have an employee table with EmpID. I now need to create another table
that would use the EmpID information. How can I easily? get the EmpID from
the employee table into the new table. Any help will be appreciated.

hanksor

 

[Lynn Trapp]

Could you explain further? Why do you need to duplicate the EmployeeID? If
it is merely going to be the foreign key in another table then you can use a
form/subform to do that.