AnsweredAssumed Answered

Merging Duplicate Records

Question asked by dwhylanjr on Nov 14, 2008
Latest reply on Dec 10, 2008 by TSGal


Merging Duplicate Records


I need some help!!  I have serached the forum and help database but I must be using the wrong search words.


I have a database that was set-up many years ago.  Each time a consumer was issued some special equipment a new record was created.  This has resulted in many records for "John Doe" with different serial numbers. 


We would like to combine all of John Doe's records into one record with a list of the Serial Numbers in the one record utilizing a "repeating field". 


How do I find all of John Doe's records and merge them together keeping some of his information (i.e. address) the same but list the different serial numbers in a repeating field?