>>Firstly, post your latest code, because, if history is any indication, we can assume anything.
>>Let's go further. Is this 'part_num' integer or character?
>
>Here is my latest code. My tag name is tComPrt and it is character.
>
>

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

Please see the minor adjustments I made and apply them. Are you sitting on the right record in crsBom?