Skip to main content
Question

text links to table?

  • June 28, 2018
  • 0 replies
  • 28 views
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.
    This topic has been closed for replies.

    • AlexWilkinson
    • Quickbase Alumni
    • June 28, 2018
    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.
    Terms & ConditionsAccessibility statement