>>>P.S.> the fastest way I found on replacing a field like this is:
>>> OPEN TABLE ONE ORDER 'UNIQUE TAG' IN 0
>>> OPEN TABLE TWO IN 0
>>> SET RELATION TO 'UNIQUE TAG' INTO ONE
>>> REPLACE ALL ONE.FIELD WITH 'SOMETHING'
>>
>>Are you sure this works? :)
>>
>>Vlad
>
>But the code with the relationship has work fine for me. I
>found it is faster than doing a
>SCAN
> seek
> replace
>endscan
>
>Charles

Your code sample will do a replace (in the child table) for the first child record of each parent record. Is this what you want? Also, you need to select an area somewhere...

Vlad