Hello everybody, i’m trying to create a mini ERP, sales management system.
Translated from english to spanish
- I have a Facturas table and also a products table.
- The Facturas table has a column related to Products Table, so you can select the product to be sold and it’s also getting the SUM of prices for the invoice’ total.
- Also, the products table has a ‘Stock’ number type column.
- Moreover, every product has a Column “Inventario” that’s summing up every time the store receives new units of this product.
- I want that everytime I create a “Factura” and select the products to be sold, it substract the equivalent units from the supply or the stock property in the Products Table.