>Is there a way the table with check for a duplicate records, let says if the records have same lastname and firstname overwrite the old record with the new record??

Something is wrong with this question. That's easy to find duplicate record, that's easy to overwrite field values. So, what is the problem?