>>>>>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