I have three point feature classes that overlay a building footprints (poly) feature class. All data is hosted on the portal, not registered with an enterprise gdb. I want the underlying building footprints to turn red when one or more of the intersecting point features has a certain attribute value. In other words, if one or more of the three points on a building has a status of "inactive", I want the underlying building footprint to turn red.
After some research, I have learned that you cannot symbolize a layer based on the attributes of another layer in the same map.
I'm looking for ideas on how I can make this happen.
Will a joined view layer help me accomplish this? These layers do have a common attribute. Would relating the layers and republishing be a better option? Will I need to rerun a calculation any time I want to see updated data? Will having this data in an enterprise geodatabase help me?
All ideas are appreciated.