AnsweredAssumed Answered

Creating a copy of a record in a different table

Question asked by kashaev on Apr 16, 2012
Latest reply on Apr 16, 2012 by philmodjunk

Title

Creating a copy of a record in a different table

Post

Hi all,

 

So I have a DB with a table for employee data (wage,hours,benifits, SS....) when that employee gets a raise of a change to his/her data I want to have the current record moved to a new table as an archive of the employees history with the company and then edit the original table's record for the employee since I have several other tables pulling info from it.  I thought about a simple "lookup" for each of the fields but is there a way to prevent that data from ever being refreshed in error?

-kashaev

Outcomes