0 Replies Latest reply on Feb 12, 2009 1:45 PM by PAF

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

    PAF

      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    -->