Hi Olaf,

Thank you so much for the code you gave me. I used the second code without index and it works perfectly. Is there a way that I could get rid of .NULL. on my notes and just leave it blank if there is no notes? Please help. Thanks, Sam

* updating parent records
Select curParent
Scan
   lcNotes= ""
   Select curChild
   Scan For curParent.iid = curChild.iid
      lcNotes = lcNotes + Alltrim(curChild.cNote) + " "
   Endscan
   Replace mNote With lcNotes In curParent
Endscan