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)


>It isn't a huge number of records. There are a large number of fields however. I wouldn't mind doing it one record at a time if need be. I simply need to copy the records and append them to the end of the table, then change one identifier field.