I'm trying to write some code that will fill a memo field. I want it to look like this:

Invoice created. 08Aug00 01:45:00
FC-3456 "24yd. Fiboptic Cable" was added on 08Aug00 01:45:00
RT-1234 "NIC 10B-T Concentrator" was added on 08Aug00 01:45:00
ET-7890 "GYS Ethnet card" was added on 08Aug00 01:45:00

I know the following code brings up errors, but from it I hope you can better understand what I'm trying to say. I'm hoping that someone will have some suggestions on how I can do this correctly.

SELECT products
local firstline
firstline = "Invoice Created "
Thisform.Edit1.Value = firstline + " " + DMY(Date()) + " " + Time() + ;
CHR(13) + ;
FOR RECORD 1 TO RECCOUNT()
prod_id + " " + details + " was added on " + DMY(Date()) + " " + Time() + CHR(13)
ENDFOR

Rodney