Look up and match function?
I'm so new to this I don't even know the correct terms to search for...
I have two tables in my database. The first is called "Salary Schedule" and has the following information:
Step Column Salary Start Date End Date
A 1 $50,000 7/1/15 6/30/15
A 2 $53,000 7/1/15 6/30/15 ....and so on.
My second table is "Employees". It also has the fields "Step", "Column", "Start Date", and "End Date". I would like a calculation (function? script?) that will automatically give me the salary based upon the date, step, and column information entered into the "Employees" table.