>Hi Sir,
>
>Thanks for the info. However, the crsBomNotes.Notes could not seem to replace the crsMLE.Notes. Here is my code.
>
>

>SELECT crsMLE
>lcNotes = ""
>SCAN WHILE crsMLE.PartNum = crsBomNotes.PartNum
> lcNotes = m.lcNotes + IIF(EMPTY(m.lcNotes), "", " ") + ALLTRIM(crsBomNotes.Notes)
>ENDSCAN
>REPLACE Notes WITH m.lcNotes IN crsMLE
>

>
>Please help.
>
>Thanks,
>Sam

You're scanning the wrong cursor.

select crsBomNotes
if seek(crsMLE.PartNum)
  scan while PartNum = crsMLE.PartNum
  ...
  endscan
endif
replace...