My task is to create a historical record of a database record change. Example: User opens a record. Modifies it. Saves it. My history table should have record1, the original record before changes. Then record2, the record after changes.
User selects record to edit.
Save that record as in an array or recordset(?)
On save in history table save original record from array or recordset, then save new record.
Then save changes in original table.
There are about 50 fields. I'm trying to avoid handling them one by one.
Does this plan make sense?
Can I create a global recordset variable, save the original recordset to it, and then use it later? Another way?