Isn't that because you've told it to update only that (those) record(s) whose PCode = Pcode.Pcode?
>below command not update all the records in "inward1.dbf"
>
>sele 0
>use pcode1
>sele 0
>use inward1
>update inward1 set inward1.vattype=pcode1.vattype where inward1.pcode = pcode1.pcode
>
>
>
>
>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.