PO & Inventory control
i feel like this is a basic question but for the life of me i cant figure out a way to do it.
i have one database with multiple tables. one is a Purchase Order (PO) that has fields paired with the product table. that pairing works perfectly. but what i would like is to have the inventory i have entered into the PRODUCT table go up and down in accordance to ordered entered into the POs.
again i feel like this should be easy but just having a brain fart. any direction would be appreciated.