Changing AND to OR

[Curlydave]

I'm trying to create a find where for when either of 2 fields equals a certain value. In Specify Find Requests, i hit "New..." On the left-hand selection I pick my table value, and in the right set my criteria and hit "Add". Then I make another one and add it below. Here's the problem: It says "AND" between the two criteria, and I want it to say "OR", but there's no obvious way to do it. There is also no obvious way to just type out the logic in one line.

How do I make an OR in a find?

Edited July 12, 2007 by Guest

[mr_vodka]

Try something like:

Enter Find Mode []

Set Field [Field1; "yoursearchvalue"]

New Record/Request

Set Field [Field2; "yoursearchvalue"]

Perform Find []

[Curlydave]

Thanks, that worked.