If I had 2 master tables…the light bulb table (lamp name, instock now) and order table (lamp and amount and complete[yes/no]). What would be the best way to accomplish when the user checks order complete then the database takes [amount ordered]+[instock now] but if the user un-selects [complete] then the database needs to [amount ordered]-[instock now]
inventory and ordering
- Thread starter tubar
- Start date
