Mk

The update statement doesn't know WHICH PCode rec you're referring to. Try:

* First select/go to the PCode1 rec of interest

lcPCode   = pcode1.pcode    && i.e. of the currently selected (required) PCode rec
lcVatType = pcode1.VatType

* You don't put in the updated field's table name

update inward1 ;
  set vattype = lcVatType ;
  where inward1.pcode = lcPCode 

HTH

Terry

>"pcode1.dbf" is product master data file.
>"inward1.dbf" is transaction data file.
>
>i think it is updating first record only.
>
>warm regards,
>mk.