ContributionsMost RecentMost LikesSolutionsEditing a report with conditional dropdownsIn my form, I have a 3 conditional dropdowns in my "Loads" table. My users will first pick a "Grower", then based off of the "Grower" selection, the "Farms" will be filtered. Then, the user will pick a "Parcel" and then a "Crop Zone". My conditional dropdowns are working great. The problem I am having is when the user goes to edit the record after they have created it. For example, they will have a parcel called "South of Railroad". The crop zone will be "Corn". They realize they entered the parcel incorrectly and go to change "South of Railroad" to "North of Railroad". When they do this, I need the crop zone field to clear out so they are forced to choose a new crop zone. When it does not clear, the incorrect crop zone will stay in the field box and will cause issues in other areas of the app. Another instance where this happens is when my users copy a record and edit the parcel name. I have used the form rules to clear out the crop zones whenever the parcel is cleared out, but do not know how to do it if the parcel name is just modified. Thanks for your help!Re: Auto fill a field based on 2 other fieldsThank you for your help! I will work on that.Re: Auto fill a field based on 2 other fieldsThank you for the reply! This is exactly what I am wanting! I believe making the key field be the formula field would be the best option as there are always new bins and Facilities being added.Auto fill a field based on 2 other fieldsI have 4 tables: "Loads Hauled", "Commercial Facilities", "On Farm Bins", and "Distance". The "Commercial Facilities" table is a list of facilities where loads can be hauled to. The "On Farm Bins" table is a list of where loads can come from. The "Distance" table is a child table of both the "On Farm Bins" table and the "Commercial Facilities" table. Each record on the "Distance" table is a distance from the on farm bin to the commercial facility to which the load is being hauled. The loads hauled table is a child table of the "Commercial Facilities", "On Farm Bins", and "Distance" tables. Whenever the form on the "Loads Hauled" table is filled out, a "Commercial Facility" and an "On Farm Bin" is chosen separately. I would like the form to automatically choose the correct "Distance" record that goes with the "On Farm Bin" and "Commercial Facility" that were chosen. Does anybody have any suggestions as to how I could achieve this? Thank you for your help.Re: Splitting, totaling, and reporting of loads by ""ShareholderI would like to thank Trinity for automating our solution for us. They were able to save us a lot time going forward with the app.Re: Splitting, totaling, and reporting of loads by ""ShareholderWe have an app that is formatted to suit the needs we have. We are just needing to figure out how to link up the Shareholder table to get the reports for the splits for each parcel.Splitting, totaling, and reporting of loads by ""ShareholderI 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 "Parcel" will have many "Loads". Each "Shareholder" will have many loads. Each "Shareholder" will also have one or many "Parcels". Each "Load" that is entered will have some amount of Bushels (unit of measure). If the "Load" has a "Shareholder", it will get split between the "Shareholder" and the business the load belongs to. An example would be "Load" 1 belongs to "Shareholder"X, The split is 40% to Xand 60% to the business. "Load" 2 may be split among two "Shareholder"YandZ. The split could be 15% toY,25% toZ, and the last 60% to the business. How could I get my app to split each "Load" that has a "Shareholder" by the split percent that is in the "Shareholder" table, and then give me a report that shows each "Shareholder" and all the split loads that belong to that "Shareholder".