Forum Discussion

RyanMamut1's avatar
RyanMamut1
Qrew Trainee
7 years ago

text links to table?

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.
App builders
Ask about Quickbase functionality
Forms
  • AlexWilkinson's avatar
    AlexWilkinson
    Qrew Assistant Captain
    7 years ago
    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.