francishunger

Relationship for doubles that does not match empty fields

Discussion created by francishunger on Oct 7, 2013
Latest reply on Oct 7, 2013 by stephensexton

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

Outcomes