S
Steve Voorhees
I have 3 separate tables that I have links using relationships. They are
using "Enforce Referential Integrity", Cascade Update Related Fields and
Cascade Delete Related Records.
My main table is a Customers table. Everything works great right now.
What I am wondering is if there is a way of "merging" any duplicate customer
records, which would then "reassign" the related records in the other tables.
For example, if I had John Smith with the same address and other contact
information, but were records 5 and 11. The process would merge record 11
into record 5, thus removing record 11 from the table, but assigning the
related records in the other unique table that had Customer numbers of 11 to
5.
Is this possible, or is there another route that could be used to avoid
duplicate customer records in the customer table?
using "Enforce Referential Integrity", Cascade Update Related Fields and
Cascade Delete Related Records.
My main table is a Customers table. Everything works great right now.
What I am wondering is if there is a way of "merging" any duplicate customer
records, which would then "reassign" the related records in the other tables.
For example, if I had John Smith with the same address and other contact
information, but were records 5 and 11. The process would merge record 11
into record 5, thus removing record 11 from the table, but assigning the
related records in the other unique table that had Customer numbers of 11 to
5.
Is this possible, or is there another route that could be used to avoid
duplicate customer records in the customer table?