I would like to perform a find on field 'A' so that it returns the records that contain either the value (say) 131 or the value 101 (but nothing else).

CORRECTION: ".. returns the records that contain the value (say) 131 *and* the value 101 (but nothing else)."

The problem is that this find will operate on top of a previous find. In other words, we cannot simply do a search to omit the first number, then constrain to omit the second number and then invert ... because this will also bring in values from the initially constrained set.

Edited September 20, 200718 yr by Guest

Enter Find mode and create separate requests for each criteria, then use the Constrain Found Set command to constrain from the previous found set.

Enter Find mode and create separate requests for each criteria, then use the Constrain Found Set command to constrain from the previous found set.

oops I made an error earlier.

What I meant to say was that we want the final found set to contain records whose field 'A' contains the number (say) either 131 or 101. So both 131 and 101 will be in the found set.

If we do a sequential constrain (first for 131 and then for 101), the first found set will have eliminated all 101 entries and there will be nothing left to constrain to in the second step.

Hi Thomas,

I thought I understood what you were going for, but now I'm confused. Now it sounds like you just need an [color:blue]OR search.

Enter Find mode

Field A = 101

New Record Request

Field A = 131

Perform Find

Lee

Hi Thomas,

I thought I understood what you were going for, but now I'm confused. Now it sounds like you just need an [color:blue]OR search.

Enter Find mode

Field A = 101

New Record Request

Field A = 131

Perform Find

Lee

Lee,

That looks like it will solve my problem.

You have an interesting use of "New record request" which I did not know before.

But I want to make sure. It does not create a new physical record ? Is it only a temporary thing while inside the find mode ?

In Find Mode, the New Record Request give you another Find Record for your request.

It is [color:red]Not creating a new record.

Lee

When you're in Find Mode, the New Record/Request step creates a new request.

YES ! Fantastic ! It worked like a charm !

Thank you Gentlemen ???