Inventory - How to?
I have three different tables on my database related to inventory:
- The products table -where stock amounts are stored
- A Line Items table -where quantity of each order is stored
- An the invoice table -where a portal shows product info and quantity ordered
However, I just can't figure out how to subtract the quantity the user inputs in the invoice portal (line items table) from the stock field for each particular item (a field that is stored in the products table). Can somebody please shed some light on how is this achievable?