How to script this find crtieria

[kfok]

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?

[Balder]

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.

[Lee Smith]

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

[Lee Smith]

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 [

[transpower]

You need two requests in the script:

1) New York, Stamford, A

2) New York, Stamford, C

You are OR'ing two AND requests.

[Lee Smith]

I only showed the first find (i.e. A).

Two find them both in the same Script than you would have to add the second request like this.

Enter Find Mode []

[-Queue-]

Close, but New York and Stamford should be separate requests.

Enter Find Mode [ ]

Set Field [City,

[Lee Smith]

Well, whatever Ken wants to find, the answer ought to be in this thread somewhere.

Lee

[transpower]

Upon rereading Ken's original post, I see that there would be four requests:

1) New York, A

2) New York, C

3) Stamford, A

4) Stamford, C

Here, you're OR'ing four AND'ed requests.

[-Queue-]

Yes, that's why my suggestion does.