AnsweredAssumed Answered

Flag duplicate email addresses

Question asked by MarcMcCall on Feb 28, 2012
Latest reply on Feb 28, 2012 by MarcMcCall

Title

Flag duplicate email addresses

Post

Is it possible to make a flag field to flag if there are duplicate email addresses that arent related Contacts through an ID_account.  I would like to set it up so that I have a field that would say "Duplicate Email in ID_Account". Im thinking I would have to run a script or something.  I dont want to set the field up as uniuqe data only, because this flag will tell me that I need to get with the customer so they can set up another email account so they can log into multiple account set up on an e-commerce site.  

 

The tables are set up like this:  Account table ID_Account.  Contact table id_account.  I know there are duplicate contacts under multiple accounts, this would enable me to lacate them through this flag and know which account to look under so I can assess how to resolve it.

Outcomes