I have made that change. However, since I have the hardware in separate
tables, computer table, printer table, etc. It is requiring in the
tblemphard to have a value in every field.

1. Should I not separate the hardware into separate tables?
2. If it is ok, then why can I not assign a computer without assigning a
printer, etc?

Thanks.



"Ken Snell" wrote in message
...
You should not have *any* autonumber fields in tblEmplHard table. They
both
should be Long Integer.

--

Ken Snell
MS ACCESS MVP

"Stranger" wrote in message
. ..
I tried to do that but access will not let me have more than one auto
number field in the table.


"Ken Snell" wrote in
:

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.