what would be the best way to keep personnel data and its history? I have an employee table with salary, postion, location etc. and would like to keep a history of changes overtime. So i know i need another table that tracks the fields that change and the date of change. I would like to update the employee table with the new data from the history table but dont know the best way to go about this. any suggestions?
In other words the Employee table would always have the current employee data and the History table would keep a history of changes over time.
Thanks in advance for any help!
In other words the Employee table would always have the current employee data and the History table would keep a history of changes over time.
Thanks in advance for any help!
