I am needing advice on how to build a relational database to easily track where a certain box is here at my work. We have a lot of boxes that contain financial records, work order numbers, and paperwork that is defined (certifications). I have made three separate tables and they all work great on their own for data entry. My issue is all these boxes are stored in one room, on the same shelf, and hold very little in common besides the shelf they sit on. My end goal here is to be able to have a report that shows 1) Where a particular box is, and 2) show who accomplished it.
I have attached a picture to show what type of boxes are separated into each category. When I return to work tomorrow, I will check to see if this makes sense. I will be more than willing to show more if I can get some inspiration.