So I have a table of records called "Publications". So I have a publication that is 'merging' with another publication. What I want is this.
Title A: The Best of Times will merge with Title B: The Worst of Times. I don't want to delete the record for Title A but I simply want to show Title B linked on the record of Title A. So a record to record relationship
The Best, Middling, and Worst of Times