Invoice for kits

[tomasreabe]

I have not found a way to do this but I might be asking wrong.


So what I am doing is I am trying to get Access to track my part inventory. What I am wanting to do is have the invoice call out the kit and then have that pull the parts out of inventory.
So as an example I would have 2 kits and 6 parts.
if you order kit 1 you get Part #s: 1,2,4,6
if you order kit 2 you get Part #s: 1,2,3,5

The second area would be to track the serial numbers of the parts on the POs and the Invoices.

[TheShabz]

Your table structure is key here. I would have three tables here.
tblParts
PartID (PK)
PartDesc
etc

tblKits
KitID (PK)
KitDesc
etc

tblKitParts
KitPartID (PK)
KitID (FK)
PartID (FK)

With this many to many relationship between park and kit, you should be able to select any kit and find all the parts associated with it. Querying off of the third table will make the PO and Invoice generation easy as you already have everything in line-item format.