>>>>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
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers