Flag duplicate email addresses
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.