AnsweredAssumed Answered

Link an hourly rate field to a record that can't change when rate increases

Question asked by BERGSTEN on Jan 16, 2019
Latest reply on Jan 16, 2019 by BERGSTEN



Simply put: I have an employee table/layout, and a payroll table/layout.


For each employee I have an "Hourly_Rate" field.


On the Payroll table, I have a calculation field set to take that hourly rate and multiply it by the number of regular hours declared on each pay period record.


The issue I have, is when the employee receives a raise, all previous records (obviously) end up altered to reflect the higher hourly amount. This makes tracking/reporting of their payment history not only inaccurate but impossible.


I already have a portal on my employee layout which creates a new record in "Employee_Link" each time the employee receives a raise (with a date reference) but I can't figure out how to connect the two.


IE: The employee earned $12/hr in 2010, so all payroll records reflect that pay rate vs. all the records in 2019 where said employee now earns $20/hr.


Any thoughts?