How do I find records using NOT

[ddreese]

What is the syntax or process I want to use if I want to do a search on an SSN field that does not have the value of "Invalid SSN"

I'm trying to do a duplicate search to find possible duplicate clients using the SSN field, but if there is no SSN entered, it will default to "Invalid SSN". I want to skip those.

- Enter find mode

- Set field SSN = "!"

- New Record/Request

- Set field SSN = :

- Perform Find

Any help would be appreciated

[Lee Smith]

Hi ddreese,

I'm assuming

You are using Version 6 or below,

That "Invalid SSN" is an auto entry resulting from the field not containing enough digits.

If so, have you tried SetField SSN = Invalid SSN and then X the Omit box.

HTH

Lee

[ddreese]

Aha! I didn't even think of the omit box. My next question is how can I set that omit box without having to manually click it (i.e. through a script)

If I manually run the find myself I get the results I want, but I'm not sure what script step I can use to check the omit box.

Thank you for the help so far

[-Queue-]

The script step is Omit Record. In Browse Mode it omits a record; in Find Mode it checks the omit box.

[ddreese]

Yep, that's exactly what it was. Thank you!

[Lee Smith]

Hi again ddreese,

Here is a tip for you. FileMaker will remember (ape) the last Find performed. So when you want to keep a find for future uses, first perform it manually, and then create a script using the "Perform Find" script step in it.

You can also edit an Existing Find script step in much the same manner. Perform the find, open ScriptMaker, select the script with the Find in it to be changed, click Okay, when the dialog box comes up, select the "Replace" next to the Find. You will also see other items that can be amended this way (Sorts, Print Setups, Import and Export Order).

HTH

Lee