Splitting, totaling, and reporting of loads by ""Shareholder
I have a table called "loads", a table called "Shareholders", and a table called "Parcels". Each "load" may belong to one or multiple "Shareholders", or it may not have a "Shareholder" at all. Each ...
We have a table for "Entities" and a table for "leases" that is linked in a many to many format through a tabled called shareholders. The Lease table is connected to the "parcels" table. A Lease may have many parcels and many entities. The shareholders table is then linked to a "load shares" table and the "loads" table is connected to the the "Load Shares" Table. The loads are linked to a "crop zone" table which is then linked back to the "parcels" table that the "leases" table is linked too. A parcel can have many crops in a year, and a crop will have many loads in a year. The Load Shares table currently allows us to "Make a new Load Share" where we can select the related lease, and then select the related Load. So in this setup we have to select each entity that is in a lease and each load that the lease applies to manually as an entry into the "Load Shares" table. We either need to automate this process, or rearrange how we are linking the information together. Maybe the attached diagram will help with how we have it setup at this point.
I am wondering about making the "Leases" table be the many to many table between entities and parcels. (Again A Lease may have many entities and many parcels) Then we would have "A Lease" that could own many loads based on the parcel name that also owns the load? Have not tried that yet. Thoughts?
