>>First of all, it is not the latest code, because you promised to use either lcNotes or m.lcNotes. Please, change it, run again, and if it still gives error then re-post it (corrected version), and answer if partnum field has the same length in both crsbom and mynotes. After you answer the question, answer another one: what is expression for 'tcomprt' index tag?
>>It is extremely important if you will keep exact sequence of the steps.
>
>Sorry Sir, here it is. I have tried running this code and it is still not copying mynotes.notes to crsbom.notes. The PartNum has the same length in both tables.
>
>What is expression for 'tcomprt' index tag? <-- What do you mean by this sir?
>
>

>SELECT mynotes
>lcNotes = ""
>SET ORDER TO TAG tComPrt
>SEEK crsbom.partnum
>SCAN WHILE mynotes.COMPRT_61 = crsbom.partnum
> IF EMPTY(mynotes.NOTES_61)
>  LOOP
> ENDIF
> lcNotes = lcNotes + ALLTRIM(mynotes.NOTES_61)+ space(1)
>ENDSCAN
>IF NOT EMPTY(lcNotes)
> REPLACE Notes WITH crsbom.notes + lcNotes IN crsbom
>ENDIF
>

Does 'comprt_61' have the same length as 'partnum'?