Multi Contractors on One Bill of Lading (1 Viewer)

tbcguytb

New member
Local time
Today, 03:08
Joined
Apr 11, 2020
Messages
1
I have an excel sheet that controls bills of ladings for a forestry company. In the example you can see that there is lots going on with this Bill. It has a payperiod, mill, truck that delivered it, etc.
I would like setup a database to monitor this. The fields CT1, CT2, Skid1, Skid2. PROC1, PROC2 are all contractor numbers. There are 6 contactors. The percentages in each line are the amount of the volume they performed In the third line there is a value in CT1 only...they get 100% of the volume. I can figure out most of this, but am stumped on how I can monitor when a contractor does multiple jobs..ie in line one, contractor 5, cuts and skids. Btw, contractor 5 now does all three as well. Each one of these jobs, cutting, skidding and processing each has their own respective rate of pay as well. I need a way to break down each line so that I can produce pay summaries for each of the contractors like the second image.

Capture.PNG


Capture1.PNG
 

Cronk

Registered User.
Local time
Today, 19:08
Joined
Jul 4, 2013
Messages
2,454
Classic many to many relationship situation. One example here

One table for bills of lading, one table for contractors and a third which has the BoL index and the contractor index.
 

Users who are viewing this thread

Top Bottom