Select Policy
Set Order to ssNumberTag in client
Set Relation to ssnumber Into client
Replace all group_code with client.group_code
This will do the same. Although, it will replace group_code with null if no record is found in client.
>> Hi, <
>> I have two tables one client the other policy. <
>> What I'm trying to do is replace a field in my policy tabl with <
>> a field in my client table. <
>> the code syntax is as follows: <
>
>> Select policy <
>> <
>> replace group_code with client.group_code ; <
>> for seek(policy.ssnumber,"client","ssnumberTag") <
>> <
>> Again, new to VFP6.0 but getting it fast. Does anyone have <
>> have anotherway of doing the same thing ? If possable, a code <
>> sample please. I was thinking of using a replace statment, <
>> but didn't know how to express it in code. <
>> thanks John <