text links to table?

  • 0
  • 1
  • Question
  • Updated 6 months ago
  • In Progress
  • (Edited)
I have a field X for a table ABC. X is a text field and the choices are a list of ID#s from ABC and they must select an ID#. When view the page, this ID# appears, but I want to know if there is a feature that turns that ID# into a link, so when you click 7 it takes you to entry #7 in ABC.

The idea is I want certain entries to be linked to sister entries.
Photo of Garfield

Garfield

  • 170 Points 100 badge 2x thumb

Posted 6 months ago

  • 0
  • 1
Photo of Alex Wilkinson

Alex Wilkinson

  • 1,036 Points 1k badge 2x thumb
You can do this by using your field X as the related record for a self-relationship. Go to the settings for table ABC, and create a new relationship where ABC is both the parent table and the child table. Quick Base will say, "Gee, this is unusual. Are you sure?" Say yes! Be careful that for the related record field on the child side of the relationship you do *not* accept the default (which creates a new field). Instead, use the dropdown to select your existing field X. If you don't see X on the list of fields from which you can choose, you will have to abort the process, change the type of X to numeric, and start over. Then on X, check the box to display it as a link to the related (parent) record.