>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<

---

John,
In VFP you can do it in a zillion ways :) A simple one is :

select policy
replace group_code with client.group_code ;
  for seek(policy.SSNUMBER,"client","SSNUMBERTag")

Cetin