ContributionsMost RecentMost LikesSolutionsRe: Splitting, totaling, and reporting of loads by ""ShareholderWe 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? Thanks for the help so far!! Re: 4 Table Filtered pick lists in formsThanks, that seems to work using the report for showing what I wanted. Doesnt seem like that is how I had it set up before, but it works and gets me to where I wanted to be. Thank You!Re: 4 Table Filtered pick lists in formsYep, I've tried that too. I can pick Parcel Name, Crop Name, or the Crop Zone Acres field from the record picker, but that limits it down and only gives me whatever is chosen in the record picker. So I go from two out of the three things down to one out of the 3 fields I am after if I choose anything other than the standard record picker.Re: 4 Table Filtered pick lists in formsThe filtering part is working correctly, its that I need one more field to get displayed in the 2nd dropdown. 2nd drop down was giving me a "Parcel Name - Crop Zone Name - Crop Zone Acres". Now it is only giving me "Crop Zone Name - Crop Zone Acres". I lost the Parcel Name in that pick list somehow.4 Table Filtered pick lists in formsI have 4 tables - "Farms" which has many "Parcels" which has many "crop zones" which has many "loads". When I enter a new load I would like to pick the "Farm" from one pick list, and the "Field - cropzone" from a pick list that is filtered based on the farm that was selected. I had this working a couple days ago, broke something and so far can not figure out how to get it back. The "Related Farm" pick list works fine. The "Crop Zone - Parcel Name" Pick list shows me the Crop zone Name - Acres, but does not show me the Parcel Name. When it was working I could pick a "Farm" such as Eitens, and then the next pick list would filter down so only the parcels that were part of Farms. So I would get an option in the 2nd pick list that looked like this 1st - "Eitens - Corn - 46 Acres", 2nd -- "Eitens - Soybeans - 30 Acres". Currently I get 1st "Corn -46 Acres" and 2nd "Soybeans - 30 Acres." Not a big problem in this case, but I could get a farm with 10 parcels in it that each has 2 crop zones in it. This would make the pick list pretty useless without filtering it further. Any Ideas how I can get this working again? The fewest number of Pick lists I can get away with would be great. Thanks