Deducting From Inventory
My company makes a medical device. I have built a database that includes separate inventory entry for every type of screw, wire, computer board, and plastic used in the device.
When one of the devices is built, I'd like to be able to create another database of final product including the individual device serial numbers. When that happens, I'd like to be able to deduct from inventory the parts that went the final device. I'm not sure how to do this so it automatically deducts the items. Can anyone point me in the right direction?