So I would like to connect a record with another record within a table, how?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

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

How can this be done that I can share a link to another record in the same table?
Photo of Cecelia

Cecelia

  • 180 Points 100 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
Okay here you go. In a distortion of reality moment I merge the Middling of Times with the Worst of Times without using any relationships:

The Best, Middling, and Worst of Times
https://haversineconsulting.quickbase.com/db/bkj62hs22?a=td

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=476
Photo of Cecelia

Cecelia

  • 180 Points 100 badge 2x thumb
Is there a way to make them links on the page?
Photo of Cecelia

Cecelia

  • 180 Points 100 badge 2x thumb
Sorry but this is quite complicated and I can really get a sense from the example you showed.  Is there an easier way?
Or a way to walk through this code a bit more?
Photo of Cecelia

Cecelia

  • 180 Points 100 badge 2x thumb
Would like further details, please see my comments.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
I created the demo very quickly before I hopped in the car. When I get a chance I can elaborate. In general I can make the "merging" behavior however you want including a link the merged record.  How specifically do you want the merged record to be displayed?
Photo of Cecelia

Cecelia

  • 180 Points 100 badge 2x thumb
So your name that says "Middling of Times" would link to that record from the Worst of Times record...thanks....
Is there also a way to share the demo with me so I can see how you did it but viewing the fields?  Thanks so much
Photo of Cecelia

Cecelia

  • 180 Points 100 badge 2x thumb
Hi...any update on this?  Thanks!