Symbolize based on related data

[MeganJohnson]

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?

[JayantaPoddar]

You could check if Joining the table solves your issue. You could symbolize the layer based on the desired Join Field.

[MeganJohnson]

Would a table join carry over when publishing the feature service? I'm trying to find a way to use relates, if possible.

[JayantaPoddar]

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]

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.

[SFM_WillBrewer]

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