I have a BD that uses a work orders table and parts inventory table. I am trying to figure out how, when I add a part to a work order it will remove the quantity of parts used from the inventory table. Seems simple but I am struggling as to how to start. Any help would be greatly appreciated. Thanks.