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.