Forum Discussion
QuickBaseCoachD
Qrew Captain
.. building on what Kigsly said above, you van use a Summary Report on the child table to get the result you are looking for. It is also possible to provide a link in the summary report which will take you to the Parent record instead of the children, as your goal is to get to a Parent, I believe.
QuickBaseCoachD
6 years agoQrew Captain
... always hectic to fly. I'm now in the air with Wifi.
You can make a Hyperlink to the Parent on the child table and do your summary on that Hyperlink field instead of the [Parent name] field. It will be a Rich Text field type.
I ways do my hyperlinks in this format to keep it KISS.
var text Words = [Parent name from lookup];
var text URL = URLRoot() & "db/" & [_DBID_PARENT] & "?a=dr&rid=" & [Related Parent];
"<a href=" & $URL & ">" & $Words & "</a>"
The _DBID_PARENT will be from the Advanced Properties of the Parent Table.
You can make a Hyperlink to the Parent on the child table and do your summary on that Hyperlink field instead of the [Parent name] field. It will be a Rich Text field type.
I ways do my hyperlinks in this format to keep it KISS.
var text Words = [Parent name from lookup];
var text URL = URLRoot() & "db/" & [_DBID_PARENT] & "?a=dr&rid=" & [Related Parent];
"<a href=" & $URL & ">" & $Words & "</a>"
The _DBID_PARENT will be from the Advanced Properties of the Parent Table.