Hi Rodney,

Try this

LOCAL firstline, cntr1
STORE 0 TO cntr1
STORE "" TO firstline

SELECT products
GO TOP && If you want to start at the top

firstline = "Invoice Created "
firstline = firstline + " " + DMY(DATE()) + " " + TIME()
FOR cntr1 = 1 TO RECCOUNT('products')
firstline = firstline + CHR(13) + products.prod_id + " " + products.details + " was added on " + DMY(Date()) + " " + Time()
ENDFOR

THISFORM.edit1.VALUE = firstline

HTH
MIke