@ScottWorld , I went through a few options to look at ways to just highlight the duplicate entries as they get entered into a database. I noted u came up with a simple one but there were no steps written down.
We have a unique patient ID which is in the primary column , we dont want to duplicate a patient file. Every time we enter we wish to have a look and see if there is a duplicate entry and delete if its highlighted. makes sense?