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

Don't you have a SET SKIP INTO TWO there, somewhere? :)