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?

I have a WORKSHEETS table; this table has a field called Worksheet Date. I have an EMPLOYEES table; this table has a field called current_hourly_salary.  I have a LABOR ENTRIES table which capt...