>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.
Look at the SET CARRY command.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer