ArcGIS Pro team
I have a map series that contains a table showing attributes. I use the query funtionality to limit the entries in the table to only those features currently displayed in the map. The limiting attribute is which "district" the feature falls into.
What I really need is to use a related table, as I have features that may be in multiple districts and so to establish a many-to-one relationship. The issue is that then straight tables (as opposed to feature attribute tables) can't be limited by the query function. They just show everything. Is there any other way to achieve this?
I'm assuming that the source of your tables are "standalone" tables in the map since the Query option in the Format Table Frame pane is disabled. This happens when the table source is not spatial - like a standalone table. You can still set a query on the standalone table so that it works with a map series. You do this using Page query—Layouts | Documentation .
For example I have a map with a US states layer that drives a map series. Each page is named by the field value for STATE_NAME. I also have a standalone table of cities and it also has a field STATE_NAME. I can set a Page Query on the cities table so that it only shows feature that match the current page.
Here is a screenshot showing the page for Montana.
I think this might be what you're looking for. Hope it helps.