PrevPrev Go to previous topic
NextNext Go to next topic
Last Post 04/17/2020 11:57 AM by  Joye
MSCM RECIPIENT table
 0 Replies
Sort:
You are not authorized to post a reply.
Author Messages
Joye
Systems Analyst II
Private
New Member
(1 points)
New Member
Posts:1


Send Message:

--
04/17/2020 11:57 AM

    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.