How can I have a look-up field that grabs the hourly salary for an employee as it was on the date that employee worked?

Hi Mark,

I have a follow up question.

Let's say that 50 labor entries were created last month, and the snapshot field captured the labor rate at $15/hour based on the above setup.  

However, this month we realized that the correct hourly rate for last month for that labor code should have been $17/hour.

Obviously we would make the modification in the Labor Rates table, but... because at the Labor Entries level the hourly rate was frozen in the snapshot field, the correct hourly rate will not update.

Is there a way to ensure that when a pay rate is updated at the parent table level (Labor Rates) with a specific effective period, any records in the Labor Entries table <with a work date that falls within that period> also get updated?