2 Replies Latest reply on Nov 4, 2013 2:35 PM by ChrisJohnston

    Compare Lists Boolean?

    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.