Discussions

Expand all | Collapse all

how to replace key field value by text

  • 1.  how to replace key field value by text

    Posted 09-20-2018 15:25
    hi ,

    Could some please help me on how to replace the link parent key field by text value.

    Eg, if i have two tables parent A and child B, the parent record id number is shown in child table , i just want to replace the parent record id by the text "go to the parent record"  which is a linked field.

    This should go back to the same as the key field.

    Thanks
    Pushpakumar


  • 2.  RE: how to replace key field value by text

    Posted 09-20-2018 18:32
    Like this?



    You can make a Formula URL field to create the same link, and you can edit the text or even make it into a button

    URLRoot() & "db/" & [_DBID_PARENT] & "?a=dr" & "&rid=" & [Related Parent]


    Edit the text under the field properties - display