If you made the "fldHardID" field in tblEmpHard an autonumber field, then
change it to Long Integer. Same for the "fldEmplID" field -- it should be
Long Integer.

--

Ken Snell
MS ACCESS MVP

"Stranger" wrote in message
.. .
Hello!!

It is under the subject of: Starting over with appending data from one
flat table to multiple relational tables.


I have all of the tables populated, however the only thing I need to do
now
is to populate the tblemphard so that the same ID number is in the
appropriate field. that should relate everything back together. However,
It won't let me do so. I think I am getting close.



"Ken Snell" wrote in
:

I didn't find the "new post"?

Anyway, yes, with the table setup I've shown, you can assign multiple
hardware items to one employee, but only one employee to each hardware.