Please will you post your table structures in the form of CREATE TABLE statements and also give some sample data in the form of INSERT statements. Also, please show what you would expect to happen when further sample data is added. It's difficult to know what you mean by duplicate data - is it where the whole row is the same, or just the primary key?

John