You may want to simplify this a bit. A couple of things to look at.
1) Instead of having individual name tables for each type of providor. Have a single contacts table. Include a field that indicates the services the contact provides. This can be a check box set allowing the contact to show up in seaches for multiple services.
2) Have a single payments table. One record per payment. The record should include the ID of the service provider, type of service amount paid, date of service and date of payment. You should be able to create reports based on dates that show all payments. If you set it up as a sub sumary report sorted by service provider's ID, you can show all of the individula payments to the providor as well as the total.
3) You have tables for adjustments. Consider adding an adjustment field, that if populated adds or subtracts from the total. You can also add a description field to describe the reason for the adjustment.
Hope this helps.
Initially I did have one "company" table to draw the names from. But, I ran into the problem of one company, many tables on the report. Each company had a name, and a rate for each of the cut, skid and delimb services. (needed later for reporting) I looked at this from the invoicing idea, one invoice, many different products. Then report on the amount of each product they purchased. A single payment table, would that mean that I have to enter 3 seperate records for eash bill of lading? The services provided field in the company table, would that be a repeating field? Or a field that allows multipe entries. Can I report on multiple entry fields?
It sounds like you could have Contact table and a Contact rate Table. In the rate table would be one record for each service the contact provides. The rate table record would have a typeof service field and rate field.
As far as the bill of lading goes, when you create one on paper, how many items go into it? Most invoices, have line items. One for each item sold... By having a single table with multiple lines it becomes very easy to report on and display related records.
You might want to look at and play with the FileMaker Invoices starter solution. It has similarities to what you want to do. I think....
Take a look at Subsummary reports. You can have a number of specifc sections depending on how you sort the information and can display multiple fields.
I'm not proposing repeating fields. FileMaker handles fields with lists of information in them. The field can be used in relationships, with functions like valuecount() to determine how many items in the field, getvalue() to pull a specific value out. These can be very handy.
I will try. I added two screen shots to the original post. We currently do it in excel. There is the recap and the final payout sheet we use.