Skip to main content
Question

How to go to grand parent record

  • December 13, 2019
  • 0 replies
  • 69 views
Hi All,

Can some help to navigate to grandparent record in a grandparent-parent-child relationship from a child record
Scenario is the below,
Consider i have three table GrandParent--> Parent --> Child

I have created a column "Link to GrandParent" and made as a reference column in the Parent table
If i take this column one step forward to the "Child" table , clicking on this link form the "Child" table will only take me to the "Parent" table . Since there is a not a  established direct relationship with "Child" table , from "GrandParent"

Can you please let me know how can i traverse from Child to Grandparent via parent table.

Thanks
Pushpakumar


------------------------------
Pushpakumar Gnanadurai
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
np,
You can simply create a Hyperlink, just like any hyperlink anywhere on the internet.  I always use the same generic format to keep it simple.

var text Words = [field which has an identifier of he Grandparent record which was double hopped down from the Grandparent to the Parent to he child you are on];

var text URL = URLRoot() & "db/" & [_DBID_Table_alias_of_the_Grandparent] & "?a=dr&rid=" & [Record ID#of GrandParent record looked up by a double hop];


// this last part is always the same

"<a href=" & $URL & ">" & $Words & "</a>"

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement