9 Replies Latest reply: Jun 26, 2015 4:58 PM by Sunny Talwar RSS

    How to use not match when it is a many to many relationship

    Lisa Clifton

      I have a functioning list box that displays all personnel who have "Qualification A" using this expression:

       

           If(match(CertTypeRequired, CertTypeName), FULLNAME)

       

       

      I'd like a list box displaying the personnel who do not have "Qualification A".  I tried:

       

           If(not match(CertTypeRequired, CertTypeName), FULLNAME)

       

      But, since my data set is a many to many relationship, there are many "Qualifications" that do not match other "Qualifications Required".

       

      Data Example:

       

      FULLNAME1

      Has:               Is Required to have:

      Qual A            Qual A

      Qual B            Qual Z

      Qual C            Qual H

       

      The If(match...) statement correctly returns Qual A.  The If(not match...) statement returns all personnel since everyone has a Qual A that does not match Qual Z and Qual H; the Qual B does not match Qual A, Qual Z or Qual H.

       

      I would like the list box to return anyone that does not have Qual H when Qual H is selected in essence comparing a many to many relationship.

       

      Anyone have suggestions?

       

      Lisa

       

       

      I am using this in an expression of a list box.  I know this is not a scripting question, but a moderator suggested I post in Scripting so I could have a chance to get better answers!   Thanks Again!!

       

      Added file Message was edited by: Lisa Clifton