ATL74
asked on
Access DB Help
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?
Attic-Box-Data-base-V8.accdb
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?
Attic-Box-Data-base-V8.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
@TheHiTechCoach, thanks but the problem is not with downloading. If I try to open his form or reports even in design mode, the database just hangs.
@ IrogSinta, Ah ... yes the database has lots of issue since there were lots pf things deleted but there are still references to them in places causing issues.. I have to recreate ting to get the database to work so I could make some edited
Notice that the table that holds your items also has a field called BoxNumber. This is the field you would use to relate the two tables.