JUst opened your mdb.
What are the field names in Salary Table???
I would expect
JobTitle some identifier representing a Job Type/Class
JobLevel (1-...)
Salary some numeric value
The other table CS-3Compilation seems to be a concoction of many different things.
However, I created a new SalaryForJobClassLevels table that is structured.
JobClass text
JobLevel number
Salary currency (could have been number)
JobClass & JobLevel is the Primary key (it is composite)
I created a query AddRecordsToSalaryForJobClassLevels that I manually used to create the records in table SalaryForJobClassLevels
I then created a query ShowNamesAndSalariesUsingJobClassAndStep that joins your CS_3Compilation table to the new SalaryForJobClassLevels
Here is the query sql (It's just a sample showing how to get data from the tables)
Code:
SELECT [CS-3Compilation].Name
, [CS-3Compilation].Identifier
, [CS-3Compilation].Source
, [CS-3Compilation].JobClass
, [CS-3Compilation].Step
, SalaryForJobClassLevels.Salary
FROM [CS-3Compilation] INNER JOIN SalaryForJobClassLevels ON
([CS-3Compilation].Step = SalaryForJobClassLevels.JobLevel) AND
([CS-3Compilation].JobClass = SalaryForJobClassLevels.JobClass);
I had to copy my revisions to a new zipfile (attached)
Note: I did move some of the salary info 1 record where there were 0's in the first 5 or 6 levels/steps
You will need to study Normalization and Data base design to move to Access or any RDBMS.