www.hkvforums.com

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

Simply use "Row_Inserted", "Row_Updated", and "Row_Deleted" server events of the "order" table. Read "Server Events and Client Scripts" in the help file for further information and more example.