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?