I'm trying to export some 200 maps of a city where on each page I've got the base cadastral, but overlayed on top is a set of affected parcels. Think of maps of block watch. If you want to show the street involved in the blockwatch program in that area, you highlight those parcels and that street but you have it on context with grayed out parcels all around. I need to cycle through a grid of 200 maps where on each page it just highlights the one street that is necessary for that sheet. Sometimes two streets are close enough together that they will show on the same sheet if you do it without a query, but I really need only one per sheet.
To code it, it would be something like "When map sheet name is 36A, show only the parcels in blockwatch 36A, show only the walk route labelled 36A" then increment to the next map sheet and repeat.
Any thoughts on this?
Thanks!
