I am making a DB for storage of various items. I have a system of containers named AB 001-AB100 which the AB stands for Attic Box and is labeled on the Rubbermaid container.
I also have CD001-xxxx and EF001-xxxx.
In the attached DB I am trying to add box color as information.I can add it to my asset details form and assets table but I may have 20 items in box AB001 for example and it's a green box and I don't want to enter that for each item. How can I add this so I only enter the box color once but it shows up on all the reports?
This is a MS example DB from the office templates website and I just deleted things I did not need and made some changes.
I also need to make a report of assets by box number but how would I do that? Would I need a separate table?