Jump to content

how many finds???


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

Recommended Posts

Are you wanting individual finds as queue suggested, or something else like.

Match any record that has one of the 5 values in Field A, and also at least one of the 2 values in Field B, and at least one of the 3 values in Field C?

Lee

Link to comment
Share on other sites

yes exactly matching any record that fits this criteria

has any of the 5 values of A

AND

any of the 2 values of B

AND

any of the 3 values of C

I was under the impression this had to be done with multiple find requests such as

Request1: a1 b1 c1

Request2: a1 b1 c2

Request3: a1 b1 c3

Request4: a1 b2 c1

Request5: a1 b2 c2

Request6: a1 b2 c3

then repeat for a2, a3, a4 and a5

am I wrong?

Link to comment
Share on other sites

Have you tried to just do a find with all of the search criteria typed in on request with just a space in between them?

Kind of like:

In Field A type

Red Blue Yellow Green Purple

Field B

Orange Apple

Field C

Orchard Box Store

FileMaker will find all records like this for one field, I sometimes do this with several fields, but the second and third fields are usually only one entry.

Lee cool.gif

Link to comment
Share on other sites

Thanks a lot Lee, I am down to 10 finds with the constrain option. However option 2 " on request with just a space in between them" doesn't work not even using field A

AB ON BC

it returns nothing Maybe because it's a field from another relationship?

thanks for your help

Zeina

Link to comment
Share on other sites

This topic is 7210 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.