I have 10 repeating fields labeled "invoice match", these all correspond with 10 repeating fields labeled "product id".

In the invoice match field there is a formula which should return "Inv Match" when the statement is TRUE. Individually they work fine, each repeating field is corresponding to the right product id. However, I need to be able to do a find that will find any record that has any product id with its corresponding Inv Match True.

I did one field with the simple calculation of, if(Invoice Match ="","","Invoice Pending") , but that is only returning the results from the first product ID, it does not look at the other 9 repeating fields. I need it to return "Invoice Pending" if ANY of those fields are True.

Thanks!

http://fmforums.com/forum/showtopic.php?tid/172033/

Look at that, it might help you

Ah!

Perfect...

thanks!

If(GetRepetition (Invoice Match , 1 ) and GetRepetition (Invoice Match , 2 ) and GetRepetition (Invoice Match , 3 ) and GetRepetition (Invoice Match , 4 ) and GetRepetition (Invoice Match , 5 ) and GetRepetition (Invoice Match , 6 ) and GetRepetition (Invoice Match , 7 ) and GetRepetition (Invoice Match , 8 ) and GetRepetition (Invoice Match , 9 ) and GetRepetition (Invoice Match , 10 ) = "","","Invoice Pending")

or

If(Invoice Match and Invoice Match[2] and Invoice Match[3] and Invoice Match[4] and Invoice Match[5] and Invoice Match[6] and Invoice Match[7] and Invoice Match[8] and Invoice Match[9] and Invoice Match[10] = "","","Invoice Pending")

or

make your field with your calc:

if(Invoice Match ="","","Invoice Pending")

a repeating field with 10 rep