>>>>>>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
>>
>>I always have a FOR TWO.custno = 'asddfg'
>> this way it replaces all the child tables values I want it to.
>>
>>Charles
>
>No, it doesn't. It replaces only the first child record.
>
>Vlad

Well it works fine for me so I'll keep using it.

Charles