@paulbrog
Certainly. The important thing to realise here is that an employee can check out
many inventory items (perhaps several at the same time), and an inventory item can be checked out by
many employees (although not at the same time). This is a particular type of relationship called a
many to many relationship between the inventory and employees tables.
To model a
many to many relationship in Access requires another table (usually called a union table), with each of the main tables having a
one to many relationship with the union table.
See the Relationships section in Mary's
normalisation article for further details.
We can help you set this up, but you'll have to have an understanding of these concepts first. Let us know if you need more help.
Jim