FMP documents well how to create a search then add to it by getting a new search (ctrl "N") from the request menu - if necessary ticking the "omit" box.

I want to do the same thing in a script to include certain values from one field, but exclude values from another - eg everyone from City A who is not Occupation B. I want to use the results of a global field to define the "include" criteria so I cant "pre-setup" the search.

Can anyone help me with the script steps ?

When you are in find mode in a script, the following script steps behave as follows:

New Record/Request - Creates a new find request

Omit Record - Changes the current find request to an "Omit" request.

So if you want to find all records where field x="hello" and field y "goodbye" you would do this:

code:

---

Enter Find Mode [ ]

Set Field [x, "hello"]

New Record/Request

Omit Record

Set Field [y, "goodbye"]

Perform Find [ ]

---

Many thanks - obvious really

SB

Make sure that the status area is toggled to "show", otherwise the Omit script step will not work! Not so obvious.

Toggle Status Area (Show)

-bd

LiveOak, I tested this a bunch of different ways, and the state of the Status Area made no difference at all. I'm using FM 5.0v3.

Can you send me a demo file where a hidden Status Area causes an Omit Record step to malfunction during a find?