I am pretty new to Access, but I am trying to set up an inventory management system for my lab using the "Lending Library" template. The thing I cannot seem to figure out is how to link multiple checked-out items together for quick reference.
For example, I have three different categories of equipment that can be checked out:
(1) Data Collection Unit
(2) Power Supply
(3) SIM Card
Each item is labeled individually, and stored in my asset list. When someone in the lab checks out equipment, they normally have to take all three of these items. I would like to quickly see which data collection unit is currently paired/checked out with which power supply, SIM card, etc.
It seems to me that the ideal way to accomplish this would be to have three separate boxes on the check-out form, one for each equipment type. Does anyone know how I could accomplish something like this? At the very least, I would like to be able to link these items together on the back end, even if I can't do it with a form.