Is there a way to symbolize feautres based on related table data? Creating a hydrant flushing web map/ Collector app and would like the hydrants that have already been inspected to be green, and the rest red. Related table contains a field for flushing status and relationship is 1:1 based on unique ID.
I know there is no way to directly symbolize based on related data but does any one know of a good work around?
Ensure the Join Table is also residing in the same database. And add the table to TOC of ArcMap before you join. Then, it should also get displayed in the map/feature service.
As of now, I haven't seen a way to symbolize layers based on Relate Table.
ESRI recently introduced enhanced capabilities for joining features in ArcGIS Online that addresses this exact issue. It is not perfect. The join layer cannot be taken offline, but it is a great start!