Our org would like to be able to see the actual defect record as of a particular history entry. I am charged with implementing this. I am not sure which approach I should take and I also wonder if someone else has already done this or something like it???
I believe I have 2 options. 1. when a record changes due to any of the actions that modify it, I can create a record (different form) that contains the values before the change and link it to the history entry somehow. or 2. when a user clicks on a history entry, reconstruct the record and show it with the field values as of that history entry. Any advice is welcome. I don't want to overload the database and I don't want performance to be too slow.
Are there any other ways to accomplish this?