AnsweredAssumed Answered

Check for Duplicates (Name in a Client DB)

Question asked by mrb13676 on Mar 4, 2018
Latest reply on Mar 4, 2018 by mrb13676

Hi

I've had a look around but cannot find a solution to this problem. I have a client database, with sales events in a linked table (one to many)

Occasionally I'll enter the details of the client again if I don't know or cant remember if they are already on my database.

Is there anyway to prevent this?

I have surname and Name fields. Of course, there may be more than one person with the same name so I would need to be able to override if I knew this was indeed a new person?

 

I've tried validating on unique value but that doesn't work.

Any one have any ideas? Could use a custom function I imagine?

Outcomes