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.

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

...

See here.

Ender got to it first. :P

Many Thanks. And Happy Thanksgiving.

Susan