So I have two tables. One is a reference table and the other is the actual data table. What I need to do is return a value from the reference table into the data table based on a number of criteria matching between the tables.
Fields in Reference Table
So I want to return the pay rate based on Instructor Type in the data table matching instructor Type in the reference table and Location Type matching and Career Type matching then if the Total Enrollment falls between the Min and Max.
I am having trouble jumping through so many criteria needing to match.