Symbolize based on related data

Question

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?

SFM_WillBrewer · Answer

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!

Visualizing related data with Join Features in ArcGIS Online

JayantaPoddar · Answer

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.

RandyBurton · Answer

There is some discussion on this topic in an older thread:  Collector: use related layer to symbolise feature.  It may have some things to try, but I don't believe there is a solid solution.