I'd like to get some ideas for an equipment tracking system. So there are about 40 laptops that will be checked out periodically to different people as needed. What is the most efficient architecture for this? I will need to track whether or not laptops are checked out. I will also need to track checkout dates and checkin dates of the past so that I can produce reports.
I was thinking something like this:
tblEquipment
--------------------
pkDeviceID (Auto)
SerialNumber (Text)
ComputerName (Text)
CheckoutDate (Date)
CheckinDate (Date)
tblTransactions
--------------------
pkTransactionID
DeviceID
CheckoutDate
CheckinDate
Checkout Button that populates the date of checkout
Checkin button that populates the date of checkin, writes the deviceid checkoutdate and checkindate to tblTransactions.
What do you guys think. Is there a better way to go about doing this?