Finding from within a find

[Mr.Morning]

I have two fields.

In field one I have a choice between three options A, B, or C.

In field two I have a choice between three options Z, Y, or X.

I have over 100 records and I want to print a report where all the option A's are found from field one and I omit all the option Z's from field two.

Can I do a combined find that finds certain records and omits others.

When I do it separate I either get all of A, B, and C with Z omitted or

Option A with all of Z, Y, X.

There must be a simple way but I cannot get it.

Thanks in advance for anyone's help.

-Morning man

[RussBaker]

You need 2 find requests to do this. It can be done either from the screen (and the find saved in a script) or it can be scripted directly. From the screen, enter Find mode and then:

First request, Type "A" in field 1

New Request, Type "Z" in field 2 and click the Omit Record in the status area

Execute the find.

To script it:

Enter Find Mode [ ]

SetField [Field1,"A"]

New Record/Request

SetfField [Field2,"Z"]

Omit Record

Perform Find [ ]

For a scripted find including the "Omit" step to work, the Status area must NOT be locked.