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.