Jump to content

Find mode-combining criteria in a single field


susan siegel
 Share

This topic is 5786 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I need some help on how to set up the following type FIND in possibly one step.

I want to search on the STATE field pulling up only records for certain states, e.g., MD, VA, NC. (I have no problem adding other fields to the find, e.g., those with email addresses in the above states and those who are "active" records.)

When I enter the criteria in the initial FIND screen, is there a way I can enter multiple states on the same FIND screen instead of doing individual finds for each state? I suspect the answer may lie in creating a script but I'm new to FM and not well versed in scripts. Or do I have to do a series of repeated "constraints"

Or, alternately, I'd like to omit from a search, all records that in the "state" field show SC, FL, GA.

Link to comment
Share on other sites

For a manual Find, the method is to add a new Request for each additional thing you want to Find. This can be done by going to Requests->Add new Request.

This can also be scripted using something like:

Enter Find Mode []

Set Field [ State ; "MD" ]

New Record/Request

Set Field [ State ; "VA" ]

New Record/Request

Set Field [ State ; "NC" ]

Perform Find []

...

Link to comment
Share on other sites

This topic is 5786 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.