Easy "OR" and "AND" question

[simone1717]

Hi,

I'm a new filemaker user (coming from Access)and I have a simple question:

when I perform a query of this kind:

Find records where Field1=(value1 OR value2 OR value3) AND Field2=value4

in access is an easy query, in Filemaker 8.5 I only succeeded in doing this by writing a script that says:

find recorde where field1= value1 AND Field2=value4

find recorde where field1= value2 AND Field2=value4

find recorde where field1= value3 AND Field2=value4

but it's very long (I have more than 30 values to put in OR inside field1).

Isn't there (I'm sure there is but i couldn't find it) a simpler way to do that???

Thanks a lot

Bye from Italy

Simone

[Keith LaMarre]

As you state it, this is a multiple search request -

But are you always looking for the same values in field 1 - if so, perhaps you can define another field as a calculation that wil "group" all of the like field 1 values together and then simplify your request.

[simone1717]

I'm sorry but I don't understand what you mean: how "grouping" fields could help me in making the query easier.

I'm wondering if there's a place in Filemaker where to write a direct SQL string..

Thanks anyway

Simone

[Keith LaMarre]

an example of grouping would be "New England" for the 6 new england states - so instead of 6 requests there is one.

obviously this only works if there are some kinds of logical groups to your data.

This is just an example