Performing an "OR" Find

[imaslowmoose]

How do I make a find show records from 2 different values in the same field. For example: a find to show all Blonde haired and Brown haired people.

[dansmith65]

Create a new find request to enter the value "Brown". 'New Record' becomes 'Add New Request' In find mode.

[bcooney]

"For example: a find to show all Blonde haired and Brown haired people. "

Actually, you want to FIND people that have either blonde OR brown hair.

[comment]

Actually, once you have found the people whose hair is either blond OR brown, you will be showing all blond-haired people AND all brown-haired people.

:devil:

[bcooney]

True that, c. I edited my post to be more specific. Boolean schmoolean.

[beverly]

But it's still an OR find and you get either (if there are NONE of one of the requests you get only the other, no AND there!). We just don't have to write a SQL query with the "OR" reserved word:

SELECT * FROM mydb

WHERE hair = 'blond' OR hair = 'brown'

It's how FileMaker works. :)

[comment]

But it's still an OR find and you get either

IMHO, it's an OR find and you get both.

To put it in more technical terms: a disjunction of predicates produces a union of sets. Or, in Filemakerese: performing a find with two find requests is the equivalent of performing a find with one of the requests, followed by extending the found set using the other request.