Our forester wants trees symbolized red if they haven't been trimmed, green if they've been trimmed. Trimming info is maintained in the Tree_Maint table, which is a one to many related table to our Trees feature class in an enterprise gdb. You cannot symbolize a feature from a related table using ArcMap. I would like to take records from the Tree_Maint table's "Activity" field with the value "Trimmed" for the current year using the "Activity_Date" field and populate the Trimmed records into the Trees attribute table field called "TRIM_STATUS". This would then allow me to symbolize the trees.
The end result of this work done in ArcMap 10.4.1 will be a feature service that our forester will use via Collector to select a tree and edit the related maintenance table, which I intend to use to update the "TRIM_STATUS".
I'm assuming this might require python, of which I am a novice.