Topic: Inventory and Invoice, how do i start doing this? Any ideas please? :)
hey guys, so my database currently has an invoice "part" that is working fairly well.
But sometimes i have to "manually" check if i have something in stock in order to see if i have to order a part or not.
I want to make a table for inventory, that works in conjuction with the inventory table, so once i add a specific item to the "invoice" sql table, i want the same quantty of items to vanish from the "stock sql table"
Also, i want it to be able to add stock back in case an invoice doesn't go through and gets canceled.
Can i follow an example from anyone so i can take any ideas?