Original User: Wnixon
Is it possible to create a report that is dynamically queried based on an attribute in a data driven pages index layer? I would like to display a set of values from a table other than the index layer that is limited to the current data driven page view. For example, I could display a table with all of the cities in a given county as I iterate over a county layer. Since the number of cities is likely to vary from county to county it does not appear to make sense to add fields to the index layer. Instead, I would like to use the "County Name" in the index layer to query the cities table and only display the cities associated with a specific "County Name" which will change with each iteration through the index layer. I appreciate any ideas and input on solutions. - Walt