AnsweredAssumed Answered

why won't my data base find email address

Question asked by weedonpaul on Dec 14, 2017
Latest reply on Dec 14, 2017 by philmodjunk

I have a contacts database that, in order to avoid duplicates, keeps email addresses as unique. when I try and create a new contact if it has the same email it will tell me and i can't add them. However if I then do a search by that contacts email address it will not find them, but tells me that I can't add them because they are already in the database. I then find them another way and hey presto they have the same email address that i just searched for. (the addresses are identical ie now additional spaces)

 

Can anyone help??

Outcomes