#RM8 : change sourceID and citationID

#1 · 2022-02-13, 1:28 am

I have a source (souceID=117) with one and only one citation (CitationID=375).

This is a bad legacy source/citation used 112 times that I want to replace.

If I create a good source with only one citation, and identify their ID numbers, is there a way to switch all occurrences of the bad combination with the good combination?

Not quite grasping the RM8 table linking yet.

Thanks,

Michael

#2 · 2022-02-14, 4:23 pm

Yes, I think so but have not done it. It would take the form:

UPDATE CitationLinkTable SET CitationID=newCitationId WHERE CitationID=375;

Pat Jones has reacted to this post.