Thanks Sergey. I thought the fields had to be listed out (haven't used that syntax in a while).

>It should be
>

>Insert into mytable from NAME loRecord
>

>
>>Using Naomi's example, if you want to use INSERT INTO, the syntax is:
>>

>>SCATTER NAME loRecord Memo
>>loRecord.field2 = m.newpk &&substitute field1, field, etc with actual field names
>>Insert into mytable from loRecord (field1, field2,...) VALUES (loRecord.field1, loRecord.field2,...)
>>

>>However, as she mentioned, if you have a lot of fields that you don't want to list out, you can instead append a new blank record and just gather the memvars or the object properties (using NAME)
>>
>>