MSCM RECIPIENT table

Sort:
You are not authorized to post a reply.
Author
Messages
Joye
New Member
Posts: 1
New Member

    Our delivery people have added recipients with no standard format over time.  We have many rows with duplicate employee ID's and I'd like to clean this table up, but I understand the associated recipient ID is also used in the DELIVERY_EVENT table, so there's the issue of violating referential integrity.  Has anyone attempted to maintain the RECIPIENT table, and if so, would you share how you went about doing so?

    Thanks in advance!

    You are not authorized to post a reply.