Discussions

Expand all | Collapse all

text links to table?

  • 1.  text links to table?

     
    Posted 06-28-2018 15:00
    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.


  • 2.  RE: text links to table?

    Posted 06-28-2018 17:49
    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.