This is both a data management and dashboard question.... I have 3 data layers representing various sizes and stages of a project (line, extent of data, boundary of project) These layers contain the unique project number while a stand-alone table tracks related project info.
I want to be able to find a project by an attribute (in the table), and zoom to the relevant geometric representation(s) - they will be overlapping. The a project related geometry could exist in one, some or all of the layers.
I can do a join/relate/query layer, but I still have to build duplicate filters for each layer which ends up being at least 9... not very user friendly.
Is there an on-the-fly way to filter or query from the parent table, find occurrences of that criteria in any of the 3 layers, and then zoom? Or build a query that searches all 3 layers for the user defined filtered info?
The kicker, I need these to be feature services dynamically updated when the techs add new records.
Open to new storage format ideas too.
