In the solution I am working on I have a table of Service records. This table has 87 fields in it. I am trying to create a Service record history table that is an exact copy of the Service record table. The only difference between the tables is the primary key on the Service record table is a unique serial number and i turned off the unique serial number on the history table. I created a one to many relationship using that field from the Service record table to the Service record history table. I want to copy the existing record over to the Service record history table when the user hits the "Edit" button.
This way, if the user makes a mistake in editing, we can go into the Service records history table, find the last edited record and restore it.
I can't think of any other way other than having 87 Set Field lines to copy over the data, and this won't scale as we add more fields to the table.
Is this possible?