"Ken Snell" wrote in
:
Hi,

i posted a more detailed description of what I currently have.

It's under the subject starting over.

I understand what you are saying below. However, would this allow me to
assign multiple Pc's to one employee?

It looks like I would be able to enter hardware without having to assign
it immediately to an employee.

I get confused with the relationships layouts. Once it sinks in I'm sure
I will get this.






I still don't have a better understanding of your setup, so let me
suggest a starting point for your tables.

I envision three tables so far:

tblEmployees
fldEmplID (primary key)
fldEmplFName
fldEmplLName
(etc.)

tblHardware
fldHardID (primary key)
fldHardDesc
fldHardSerialNum
(etc.)

tblEmplHard
fldEmplID
fldHardID (primary key)


The third table allows you to "match" an employee to a piece of
hardware.