how many finds???

[Zeina]

if I have a selection criteria that requires

5 values of field A (out of 10 possible values)

2 values of field B (out of 4 possible values)

and

3 values of field C (out of 6 possible values)

How many find requests do I need?

[-Queue-]

Assuming they are independent searches, 10.

[Zeina]

shouldn't it be 5x2x3=30???

[Lee Smith]

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

[Zeina]

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?

[bruceR]

Seems like it could also be done with 10 requests using constrain found set. Find first 5. Find 2nd group using constrain. Find last 3 using constrain.

[Lee Smith]

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

[Zeina]

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