>Hi Sir,
>
>I have a Part Number that has two notes. For example, in my crsBomNotes with Part Number 101010, it has R1, R2, R3 on the first Note and R34, R35, R36 on the second row. I am trying to put all the notes in crsBomNotes to crsMLE.Notes per given Part Number.
Just
replace crsNotes.notememo with alltrim(note1)+" "+alltrim(note2)
assuming you got the notes in variables. Or, if you're going through a loop,
select crsNotes
lcNote=""
scan while pk=mypk
lcNote=lcNote+iif(empty(lcNote), "", " ")+alltrim(note)
endscan
replace notememo with lcnote in crsBomNotes