AnsweredAssumed Answered

Look up and match function?

Question asked by JessikaWelcome on Jul 8, 2015
Latest reply on Jul 9, 2015 by JeffTomb


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.