Hey guys,
I have what I think is a straightforward question but I cannot figure it out on my own.
Some backround info: I am building an RMA database where customers send in a broken product and we use parts and labor to fix it. We need to run monthly reports on all parts used across all RMA's.
Database structure: There are three tables which are Customer, RMA, and Parts. Currently, I have the RMA form setup so you can pick a part from the "Parts" table and it stores the PartID in the "RMA" table so we can associate all parts used for each individual RMA. That is all working, and the RMA table is storing all the PartID's (typically 3-15 parts per RMA) used for each RMA
My question:
I need to make a query that shows the total number of parts used each month across all RMA's. I need to show the item number, item description, and the total number used of each. I can make a querry that shows all the PartID's used each month, but I need to show the associated information such as description and item number. Can please you offer advise about how to achieve this?