am attaching sample database-
am trying to understand how to make a many to many relationship with two tables.
have created the 2 tables-[tblItems] and [tblParts] and a 3rd table to make the junction.
but that is as far as I can get?
can a report be created with items with the same category number be listed and then right below have all the part numbers and the same category numbers below them?
Item descr qty category category number
Printer 51 HP 101
Scanner 65 HP 101
Monitor 84 HP 101
Printhead 15 HP 101
fuser 26 HP 101