dynamic filtering based on selected layer in arcgis desktop

Discussion created by on Feb 20, 2018

I am not sure this is even possible, I have about 38 geographical polygon layers showing areas of the UK, I also have a query (point layer) that shows all of the offices around the uk. What I am attempting to do is if I select layer 1 that only the offices that intersect with displayed polygons are show. Then if I display an additional layer or change the displayed layer the shown points change accordingly. Image one shows offices outside and inside the layer polygons, Area One Image two I have switch the polygon layers but I want only the intersecting offices to show.Neighboring area two I could do this with having 38 separate attribute queries but that seems an excessive amount of work.