Update newer record with older fields

[ellenr]

My table occasionally gets a second record added for the same person. What is the easiest way to update the new record with the non-zero fields from the older record, then delete the older record? There is a unique id field as well as a timestamp, so knowing which is older isn't a problem. Is there an easy way to do this?

 

[brharrii]

Why not use the unique ID as a primary key so that duplicate records can't be created?

 

[ellenr]

The duplicate occurs when they enter an update to their resume via online form. I want both records so I can programatically update the new record with certain fields previously entered in the original record. I finally solved it with a series of queries; choosing only records with duplicate names, then doing an update query. It wasn't the most beautiful solution, but it works.

Thanks for responding.