Deleting Duplicates from a Table

[ITProg]

I have 2 tables: tblReviews and tblHistory. At the end of the month data from tblReviews will be appended to tblHistory. At the time that I append the data to tblHistory I would also like to make sure there are no duplicate records in tblHistory. tblHistory can have more than one record for a person, but should not have more than one record for that person for the same date. Since the data is not being deleted from tblReviews when it is appended, it is a possiblity that there could be duplicate records that should not be added to tblHistory. I am using an autonumber field as the primary key in tblHistory. tblReviews has a staffno as the primary key.

 

[gwog]

Why not make the primary key in tblHistory a combination of fields for person name(or id) and date. Then when tblReviews appends it would not append duplicate values.