Relating transactions with Rate Master Table

[JoeyB_99]

I am using Access 2007 and have inherited a database. It has linked tables of Excel spreadsheets that are information extracted from our main system. The user wants help in developing a much faster and customized approach to billing the customer based on payroll related information.

There is a table of payroll billing transactions and it has the following record lay-out,

job_num, employee number, employee name, union group, rank, regular hours, overtime hours, other hours, trans_date, seq_num

6430, 2301, john doe, 1, F, 8.0, 0.0, 0.0, 12/01/2012, 254333

On December 1st John Doe worked 8.0 regular hours as a pipefitter foreman on job number 6430 and this is record (sequence) number 254333.

There is another table that defines the union group. I am not concerned with this information at this time. The seq_num is a sequentially and uniquely assigned number given to each billing record in the main system.

There is also a Rate Master table and it has the following record lay-out,

job_num, union group, rank, regular_billing_rate, overtime_billing_rate, other_billing_rate

I am struggling as to how to relate these two tables so that I can develop some queries from it.

Any help would be greatly appreciated.

 

[JoeyB_99]

Thanks Pat, that should work. I will give it a try.