>Hi Cetin,
>I used the sample you gave me :
>
>> SELECT POLICY <
>> REPLACE group_code with client.group_code ; <
>> for seek(policy.ssnumber, "client","ssnumberTAG") <
>> Placed this code on a form in a command button, it runs very slow. <
>> Could you give me another sample ? <
>
>> Thanks <
>> John <

---

Very slow ? Generally these type of updates are "run once" type things. Might it be that in fact you only need to update just one per click ? This would whole policy table from top to bottom. If just one then it would be :

REPLACE group_code with client.group_code ; 
 for policy.ssnumber = client.ssnumber ;
 in "policy"

* Or Update - SQL
update policy ;
 set group_code = client.group_code ;
 where policy.ssnumber = client.ssnumber

Cetin