I have a series of individual parcels with multiple soil sample points on each parcel. I need a way to communicate the soil sample information to the landowners. There are about 500 parcels so I need a way to automate the creation of maps and a report of the soil analysis, which is in a series of related tables (Site data --> Soil Horizon Info --> Horizon Analytical Results).
One of my solutions is to flatten these tables into a database row for each point, do a spatial join and append the soil point data to the parcel polygon, but this is very time consuming to manually transpose these related records in Excel.
Is there a faster way to use data driven pages and dynamic text on the map layout displaying related data?