I create two Tables name ItemDetails and OrderDetails. ItemDetails Table has a Column name QuantityInHand and OrderDetails Table has a Column name QuantityReceived, and i need to perform the following.
1. QuantityReceived should be added to QuantityInHand in the Items table.
2. When a record is inserted into QuantityReceived, QuantityInHand in the Items table
should be updated automatically.
Pls what Query are my To type.....