1 Reply Latest reply on Mar 11, 2015 2:02 PM by philmodjunk

    Storing historical data

    debbie.y@ccsjc.com

      Title

      Storing historical data

      Post

      I am setting up a personnel data base and would like to keep the history on wage changes.  The data I'd like to store is the date of the wage increase and the previous wage amount.  Is there a way to set up a field to story past history?

        • 1. Re: Storing historical data
          philmodjunk

          It would be better to set up a related table for past and current wage information. This can all be linked by an Employee ID number to the employee record and the effective date of the wage change logged in this table for a given employee can be used to make sure that you are using the current wage for payroll purposes while still keeping past wage data in additional related records.