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.
Best Answer
This article helps guide you to the answer as well: https://community.esri.com/message/772784-re-collector-use-related-layer-to-symbolise-feature?commentID=772784#comment-772784 If you look at the section where JerryC and myself chat, we talk about adding the parent fc as many times as you need to place an individual definition query in the parent fc. The definition query would search all the unique ID's in the parent fc, then search the related records for the unique ID that matches the parent ID, based on another delimiter, such as latest datetime field, and finally another delimiter such as the trimstatus. You can then symbolize the resulting fc according to the query you input. The following url describes my understanding of this as of now: https://community.esri.com/thread/215046-symbolizing-feature-class-using-related-table-values