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