Subtracting Parts used in Manufacturing (Inventory Management)

[Suzanne_Ransom]

I'm trying to create an inventory management base. I have two products that use several parts to make. I want to be able to enter the quantity when I buy the parts, and then when I manufacture, have those numbers subtracted from the quantity of each part.

So product COF01 uses 1 jar, 1 lid, and 1 desiccant with 70 grams of coffee. I don't know how to get the 1000 quantity manufactured to translate back to deducting 1000 pieces from each part and then 1000x70 from the coffee product.

In my products table, I don't know if I can list all the supplies in one field or if each piece needs it's own field.

I feel like this should be simple but I'm completely stalled.