Database design for Lending Library
Posted on 2009-04-08
I am creating a lending libary database - much like in a real library, or movie store. I am having some issues in constructing the design.
Subject: Tools in a company are being checked-out.
TActive = yes/no
I need to create a form that will allow a user to Fill in the following:
Supervisor Name, Date Checked out, Date Returned,Tool ID,
The problem is how can i place multiple Tool Ids with one Checkout ID?
Since a person can checkout multiple tools.