Find "either / or" ?

[Thomas An]

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, 2007 by Guest

[Ender]

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

[Thomas An]

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.

[Lee Smith]

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

[Thomas An]

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 ?

[Lee Smith]

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

[Ender]

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

[Thomas An]

YES ! Fantastic ! It worked like a charm !

Thank you Gentlemen ???