It's REPLACE ALL, but make sure you have the Policy table selected first.
>Hi,
>>I'm trying to update a field in a table using another tables field.<
>>If I were to write it out in code it would sound like this <
>
>> SELECT CLIENT, POLICY <
>> I'd set the relationship between the to fields as SSNumbers. <
>> I'd then issue <
>> replace all policy.group_code with client.group_code ;<
>> for POLICY.SSNUMBER = CLIENT.SSNUMBER <
>> IN VFP, HOW DO YOU WRITE THIS EXPRESSON, IS IT UPDATE FOR OR <
>> REPLACE ALL ? <
>> pLEASE HELP <
>> JOHN<