Duplicate Records

[Jim Rodman]

I have an online evaluation form with three important
fields, comment, conference, and location. I need a
utility that will delete duplicate records when a user
submits an evaluation more than once, and the three
fields are duplicated exactly.

 

[Tim Ferguson]

I need a
utility that will delete duplicate records when a user
submits an evaluation more than once, and the three
fields are duplicated exactly.

Prevention is better than cure: if you have two records referring to the
same evaluation, how do you know which one has the correct values?

I'd suggest creating a unique index on the three columns so that the engine
will not let the duplicates get stored in the first place. "Let the server
do the work..."

For the existing errors, there is a Find Duplicates wizard in the New
Queries command.


HTH



Tim F

 

[Bruce M. Thompson]

I have an online evaluation form with three important

fields, comment, conference, and location. I need a
utility that will delete duplicate records when a user
submits an evaluation more than once, and the three
fields are duplicated exactly.

You can create an index containing the three fields. In the "Indexes" dialog,
give your index a name in the left column, then select all three fields in the
right column, one row per field, and set the index's "Unique" property to "Yes"
to prevent generating the duplicate records to begin with.