Leaving out records by search criteria

[kaaltje]

Is it possible to write a script to leave records out based on certain criteria?

In this case, I have records of people, but some have the status INACTIVE.

I already have a working script to search for certain records and have them displayed in a new layout (thanks to Quintech, Jerry) but now I want to add something to this script so that the inactive people are left out in the search results.

[Wim Decorte]

The find can have more than one criterium. Make the second criterium (also named request): status = inactive

[kaaltje]

But then it will show the records that are inactive. What I want is a selection of the records that answer to my first criteria and which are active. So I need to leave OUT the inactive ones.

Because I only want to fill in something about a status when they are inactive I want to do it this way by searching for inactives and leaving them out of the search result.

[Ender]

You could search for Status = "Active" if the only choices for status are Active and Inactive, or omit those with Status = "Inactive":

...

Enter Find Mode []

#Your find requests

New Record/Request/Page

Set Field [ "Status", "Inactive" ]

Omit Record/Request

Perform Find[]

...

[kaaltje]

It's very stupid but I cannot the "omit record/request" line. I have a Dutch version of Filemaker 4. Do you know if this version might not have the possibility?

[Lee Smith]

Hi kaaltje, and welcome to the Forum.

The script step you are looking for is listed on the Left side (in the Script Edit Window), under the SortFindPrint group heading. On my copy, it is one click down using the scroll bar. It is also available in the find window. It is a white box Above the "Find" button.

HTH

Lee

[kaaltje]

Thanks very much, it's working now!!