can this replace correct value in all records.

in "pcode1.dbf" 100 records with different "vattype" value
pcode : 101
vattype : Qty x Rate

pcode : 102
vattype : Qty x MRP

pcode : 103
vattype : Qty x margin

is below command work perfect :

update inward1 set inward1.vattype=pcode1.vattype

warm regards,
mk.