Jump to content

How do I find records using NOT


This topic is 7143 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 smile.gif

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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 smile.gif

Link to comment
Share on other sites

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

cool.gif

Link to comment
Share on other sites

This topic is 7143 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.