how to replace key field value by text

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • Answered
  • (Edited)
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.

Photo of Pushpakumar Gnanadurai

Posted 11 months ago

  • 0
  • 1
Photo of Everett Patterson

Everett Patterson

  • 1,058 Points 1k badge 2x thumb
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