We would like the user to select a non-spatial table record and have the map display related features in a feature class. Many records could relate to the same feature, and many features could relate to the same record. Our use case is this: A water distribution company needs to flush mains down a specific corridor. There are certain valves which would need to be turned off in order to control the flow in a particular direction. Some of those same valves would also need to be turned off in order to control the flow in a different direction. We would like the user to select a record in a non-spatial table. This record describes the direction and other information the user needs to operate the flushing program for that area. When that record is selected, the valves participating in that flush would be highlighted.
Is there any sort of support for this in any of the AGO products?