newbie - find duplicates and update field of first id help needed

F

fishy

I have a database where if a customer has more than one record, by updating a
"primary id" field with the record number in the "id" field, an event
procedure changes an outcome status to prevent repeat marketing. I need a
solution that would identify when a telephone number is duplicate of a prior
record and to update the primary id with the first record id and run
procedure. This will work either when agent inputs data or by running a cmd.

Any clues?
 
Top