simone1717 Posted September 18, 2006 Share Posted September 18, 2006 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 More sharing options...
Keith LaMarre Posted September 18, 2006 Share Posted September 18, 2006 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. Link to comment Share on other sites More sharing options...
simone1717 Posted September 19, 2006 Author Share Posted September 19, 2006 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 Link to comment Share on other sites More sharing options...
Keith LaMarre Posted September 19, 2006 Share Posted September 19, 2006 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6564 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 accountSign in
Already have an account? Sign in here.
Sign In Now