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?
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.