merging two duplicate contacts/CfoldFusion

Posted by jil on Stack Overflow See other posts from Stack Overflow or by jil
Published on 2010-03-25T01:31:51Z Indexed on 2010/03/25 2:23 UTC
Read the original article Hit count: 432

Filed under:
|

having to do with data integrity - I maintain a coldfusion database at a small shop that keeps addresses of different contacts. These contacts sometimes contain notes in them.

When you are merging two duplicate contacts, one may be created in 2002 and one in 2008. If the contact in 2002 has notes prior to 2008, my question would be does it matter if you merge these contacts and keep the 2008 contact's ID number? Would that affect the data integrity or create any sort of issues with the notes earlier than 2008?

I hope I've accurately described my scenario, as I am not familiar with the proper technical terms.

I really appreciate the help sir!

© Stack Overflow or respective owner

Related posts about coldfusion

Related posts about database