Mk
The update statement doesn't know WHICH PCode rec you're referring to. Try:
lcPCode = pcode1.pcode
lcVatType = pcode1.VatType
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.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.