4 Replies Latest reply on Oct 7, 2013 2:57 PM by stephensexton

    Relationship for doubles that does not match empty fields

    francishunger

      Hi,

       

      I'm using a selfjoin-relationship and a portal to warn my users about potential doubles in their address database. lets say for example the relation is firstname = firstname AND lastname=lastname AND ID <> ID. How do I omit that this relation matches empty fields in firstname or lastname and returns a valid relation...

       

      Thanks in advance, Francis