The SEEK and REPLACE should be faster anyway.

>I see, thanks a lot. I wish we already were using VFP9.
>
>Well, I would go with scan then, because I don't like that kludge solution.
>
>>See Re: SQL Update Message #974571
>>
>>>
>>>Is it possible to update one table based on another?
>>>
>>>Here is my attempt:
>>>

>>>UPDATE trans SET cCommissioned_Owner = curt.cOwner WHERE trans.ctrans_pk = Curt.ctrans_pk

>>>
>>>In curt I put two records, but only one record was updated in Trans. Is it possible to do or it would be better to scan curt and update one record in a time (or use replace command - which is better?)
>>>