Bill of Ladings Relationship question

[tbcomputerguy]

Is it possible to assign 3 seperate companies to one invoice with each company providing possibly more than one service (each service has its own rate) and then show a sub summary report displaying values sorted by the company, then by the service and a total value of all services performed?  l have tried many ways to no avail.  We currently use excel...one spreadsheet for the bill of lading recaps and one spreadsheet for the paysheets.  There is the possiblity of mistyping data when transferring totals so we want to put it in one database.

 

I and answer more questions if neccessary.

 

Dave