Update record in another table, to add, modify and delete a record
Table 1: store
Structure: id_product, product, quantity, price, details
Table 2: order
Structure: id_order, name, client, id_product, quantity
When you add, edit or delete a record in the table "order" , will add or subtract the quantity of the selected product from table "store".
Thanks for your support