>>>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?
Sorry about that, I did not mean to ignore you. The above was my original code. This is still not working.