How to write a script that selects multiple items in one field?
<!-- StartFragment -->
I know this is probably a very stupid question, but here goes.
I am using FM Pro 9. I have a field called "County" that holds data for seven different states with 50,000+ records. I also have a "state" field.
<!-- EndFragment -->
To find a combination of "county and "state" I can use the "Find" command followed by repetitive "Add New Request" commands. When you're looking for 25 counties in a single state this method can get a bit cumbersome.
I tried to make a script, but ran into some problems:
"Specific Find Request"
District::State Province 1 "IN"
AND Districts::z_County "Orange"
It does find the records in Orange county, Indiana, but I can't figure out how to get it to find the other 24 Indiana counties I need all in one fell swoop.