Currently child table has multiple designs with versions and parcel counts. Parent table only has the designs. I would like to get the latest parcel count for each design.
Child ~~~Design A: v1 - 100 parcels, v2 - 200 parcels, v3, 175 parcels
I would like to have the latest parcel count of each design in parent so...
Parent~~~ Design A: 175 parcels
I know you have to do a maximum of record ID from child but having a road block on making that relationship.