I was wondering if there is an easy way to add a new record to a table, but I want the data from the previous record (used to be the last record in the table prior to APPEND) to appear in the new record. It's like a duplicate record is created on purpose. Only the record ID would be unique between the two records all other fields would be the same information.

I thought about using APPEND FROM, but that means I would have to copy the table to a temp table first and then APPEND FROM the last record from the temp table to the last record of the permanent table.

It's almost as if I want a new command called APPEND FROM table -1 so I append a new record, but all the fields are carried over from the old last record. Thanks for the help.