|I am working an inventory sheet for work. I have a product that uses multiple parts. I want to keep track of all the orders for my products. So lets say I have 5 thingamagig orders placed for varies customers. I need my database to subtract from my stock list so I know how many parts I have left and in turn letter me know how many thingamagis I can currently send out and how many of what parts I need to order to get my stock level up so I can ship.|
1 Thingamagig uses (1 part A, 4 Part B, 3 Part C, 1 Part D, 1 Part E, 1 Part D)
I have different products that use the same inventory.
Any help would be great.