AnsweredAssumed Answered

Compare Lists Boolean?

Question asked by ChrisJohnston on Nov 4, 2013
Latest reply on Nov 4, 2013 by ChrisJohnston

Title

Compare Lists Boolean?

Post

     I have the result in a return separated list (it came from ExecuteSQL) something like this:

     DOC000000095

     LNK000000080

     LNK000000081

     I also have another list

     DOC000000081

     DOC000000088

     DOC000000089

     DOC000000090

     DOC000000091

     DOC000000093

     DOC000000094

     DOC000000095

     DOC000000096

     What is a way FileMaker can say if any of the values in List 1 exit List 2 evaluate as true? I was trying to use FilterValues ( ) Inside of PatternCount () but it went sour and I forgot the whole plan.

Outcomes