AnsweredAssumed Answered

Preventing Duplicate Records

Question asked by laguna92651 on Nov 14, 2012
Latest reply on Nov 15, 2012 by laguna92651

I am generating a set of records in a table called PRODUCTS, using a looping script, based on records in a table called SIZES. The records created would be of the form;

 

DM12013-2

DM12013-4

DM12013-6

DM12013-8

 

What changes do I need to make so a record is not created (duplicate record), if the record already exists in the PRODUCTS table.

 

If DM12013-2 already exists I do not want to create a second copy of it. I would not want an error message, but the script to just go ahead and create the remaining records for the PRODUCTS table.

Outcomes