Jump to content

Easy "OR" and "AND" question


This topic is 6457 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

This topic is 6457 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.