Jump to content

How to script this find crtieria


kfok

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

Recommended Posts

I have two fields: City and Affiliations. Affiliations is a value list

field which have values, say A, B, C, D.

I want to find records based in New York AND Stamford AND with either

affiliations of A OR C.

How do I script this find?

Link to comment
Share on other sites

Kfok,

I see only one possibility (but i maybe wrong...):

find modus : search for New York, (dont'press enter)

goto >request > add new request

search for Stamford. Press enter.

Now create a script with 'Perform find', restore, replace found set.

Loop through the records all delete all records where affiliations not equal A or C.

Link to comment
Share on other sites

Hi kfok,

You want to do an "AND" Find.

An "AND" find will find only those the records that meet "ALL" of the criteria. Your request should look like this:

Enter Find Mode

Type in Field1 = New York

Type in Field2 = A

Type in Field3 =Stamford

Hit the Enter (Return) Key

An "OR" find will find records that meet any Criteria for each of the requests. That would look like this:

Enter Find Mode

Field1 = New York

New Record Request

Field2 = A

New Record Request

Field3 = Stamford

Hit the enter key

This will find records that either meet the criteria of request one, Request two, or Request Three.

HTH

Lee cool.gif

Link to comment
Share on other sites

Addendum to my other posts.

I got caught up in how Balder had explained the finds, and overlooked the fact that you were wanting a script.

To hard code a script, just change the find to something like this. Open ScriptMaker, name your script and use these steps.

Enter Find Mode []

Set Field [

Link to comment
Share on other sites

This topic is 7195 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.