AnsweredAssumed Answered

How to write a script that selects multiple items in one field?

Question asked by PAF on Feb 12, 2009

Title

How to write a script that selects multiple items in one field?

Post

<!--       StartFragment       -->

Hello,

 

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.
 


 

Any assistance would be greatly appreciated.

 

Grazie.

 

Pam
 

<!--    EndFragment    -->

 

<!--    StartFragment    -->

Outcomes