With this model I'm trying to iterate through a polygon feature class that contains different areas in a city. I'm using the Select by Layer by Attribute tool to specify a starting point in my file to begin the iteration, which in this cases is "Object_ID = 1". Then I'm using the Select Layer by Location tool to select all the sewer services that are located in these areas. I know this is where my problem lies. FYI, the portion of the model where the problem is starts at the bottom half from the blue oval titled "FeaturesBeingSelected". The model then continues to attempt to run Summary Stats for each of these areas and is set up to return a table with the count for material type for each area. Each table is the output with the appropriate name for the area and written to a geodatabase.
Here's the problem: I noticed all the tables are coming out empty except for the first table. I was able to figure out that Select Layer by Location tool is Not reselecting the sewer services each time it iterates through each area. I'm kind of in a crunch for time otherwise I would fiddle with this more and figure out how to make this work.
Can anyone help me with this please? I feel I've missed something pretty simple.
Thanks,
Mark