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?

This last question is what I was looking for. I wanted a way to do this without the snapshot function. The payment amount would calculate based on the last effective pay increase date that is before the date of labor.