Exclude problem !

[Cadderly]

I want to do a search with exclude. With scriptmaker, I don't able to check the checkbox Exclude or to enter a character in the field to do this. I try "not", "<>" before the value and it don't work.

Help me !

[Mike D.]

Do your search first before scripting it. Then, in your script use the Perform Find [Restore] step. It will remember the search you just performed.

HTH, Mike

[LiveOak]

This will work, while I try to avoid Find[restore] as it hides the actual search. Instead I prefer to explicitly set the paramenters of the search. You can perform an "Omit" under script control by using the "Omit Record" script step.

Enter Find Mode []

Set Field[First Name, "John"]

Set Field[Last Name, "Smith"]

New Record/Request

Set Field[City, "New York"]

Omit Record

Perform Find []

-bd

[Mike D.]

LiveOak,

I agree with you. Your method is the elegant (preferred) solution, while mine was the quick and dirty.

Mike

[Lee Smith]

hi Cadderly,

In FileMaker, Exclude = Omit

Much easier to find the answers to questions in the online help and FileMaker Manuel if you use FileMaker's terminology.

Lee