Tbljobs has a field PrevWageID, which will contain 1 of 4 prevailing wage types for this area, listed in the table on the left (2 columns).
These are two tables which need to be related. However, there are different wages for each ID. I am just stumped as to relate these. The Job description ID (1st Column) is a field in the employee table; however, if it is a prevailing wage job, the 3 column is entered in QuickBooks, which assigns the prevailing wage rate. I am listing only one rate which is for Miami-Dade Heavy Construction. There are 3 more tables. I would set it up in QuickBooks to have the PwID MiaLight start with a 2, Broward with 3 and 4.
ID Description JobDescIDF PWDescr PwIDMDH MDHRate MDHFringes 1 MiaHeavy 1 Foreman >5 Empl 1F 23.98 6.02 2 MiaLight 7 Oper. Eng Group V 1T 20.35 8.50 3 BrowardHeavy 18 Oper. Eng Group III 1N 22.00 8.50 4 BrowardLight 10 Oper. Eng Group IV 1O 21.44 8.50 15 Laborer/Journeyman 1L 14.50 4.67 16 Skill Labor w/tools 1S 15.00 4.67 17 Carpenter/Journeyman 1C 22.20 6.02