Duplicate record detector...

R

RebootKidFL

Hi

I'm working on a database application which needs to have a "dupplicate"
detection tool for records. OK Point is that: if three fields are actually
repeated (on different Records) a message is suppoust to print on the screen
in order to get the user warn there's a posible duplication of a record or of
a "procedure". -->It's for an insurance company<-- so in order to detect a
"dupplicate" of a "procedure"; I need to do a "procedure" to detect that.
Point is that I can not use the "Primary-Key" because there might be a
duplication of a field when if a "patient" asked for a second opinion to
another phisician. Or another medical procedure from another phisician.

I hope this story does makes scence.

Reboot Kid
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top