Solved! Go to Solution.
My goal was SELECTION (on the original 'Points' layer) based on a field value from a selected recordset in the Related table ('Points1.dbf').
Hi All,
Trying to Select Recodrs By Attribute from a feature layer (e.g. Points.shp) based on the field value from a related table (e.g. Points1.dbf). If I run the model as-is (see screenshot), the result is a table view and 4 feature layers (e.g. FLayer0, FLayer1, etc.) in TOC (corresponding to the records in the table view based on my expression). Each 'FLayer' has 1 feature selected in it. However, what I've been trying to achieve is to select all 4 records in a single feature layer. I used ADD_TO_SELECTION selection type on the 'Select Layer By Attribute' tool, but the model doesn't seem to be respecting that. As soon as I remove the %n% from the 'FLayer' output, I end up with FLayer0 with 1 selected feature in it (the selected feature is the last one in the table view, which indicates that the model has iterated 4 times as it was supposed to, but for some reason overwritten all previous selections).
Any ideas on how I might be able to fix this?
Thanks,
Max
Hi Max,
see if Append or Merge get you there.
Barbara
My goal was SELECTION (on the original 'Points' layer) based on a field value from a selected recordset in the Related table ('Points1.dbf').