m.cain

Selecting records based on another record

Discussion created by m.cain on Dec 20, 2011
Latest reply on Dec 20, 2011 by m.cain
Hello,

This is what I want to do:

1. A user specifies a String value (input parameter to a model).
2. A record R1 is selected in a shapefile's attribute table based on matching that string value to value in field A.
3. A 2nd record R2 is selected in the shapefile, where (double value in R2's field B > double value in R1's field B) AND (R2 field B's double value < double value in R1's field B + 3)
4. A 3rd record R3 is selected in the shapefile, where (double value in R3's field B < double value in R1's field B) AND (R2 field B's double value > double value in R1's field B - 3)
5. Records R1, R2, and R3 are exported to a separate shapefile.

I'm sure this is possible, even if I have to have 3 intermediate feature class outputs along the way. I can do up to step 2 using ("field A" = '%String%'), after that?

I'd appreciate your thoughts.

Outcomes