Tables

[TC]

I am attempting to build a equipment maintenance database for a construction
company. I need to be able to pull a report that shows every part for a
piece of equipment. I would like to be able to enter in an equipment number
and pull a report for that piece of equipment. I can't figure out how to
arrange the data I have into tables so I can build the report.

I would also like to build a form for data entry. Date of service, type of
service, which piece of equipment..etc. I am totally lost with Microsoft
Access 2007.

 

[Arvin Meyer [MVP]]

Since it is possible to have the same part on multiple pieces of equipment,
you should use 3 tables.

1. tblEquipment
2. tblParts
3. tblEquipmentParts

Look at the Orders, Products, and OrderDetails schema in the Northwind
sample database that came with Access for an example.