hi expert, i have a probelm ,  i have table purcahseline which have column as
 PoId Qty    company    Itemid ItemName
 having multipel records, now when i used update query on this table, suppose it have old record
 PoId Qty Company itemId Qty
 01 20 aa ac-00002 Potato





when i update the record (qty) from 20 to 10 then there add a new field in same table which show me difference between old value and updated value.