Hi Arshad. The hyperlinks in those summary fields encode a set of query parameters to retrieve and display the related child records. You could accomplish what you're trying to do in a child table that looked up the summary field if you create a formula text field in the child table where you want the hyperlinked summary field to appear.
Imagine there is a Purchase Orders table that has child records in an Items table. The Purchase Orders table summarizes a count of items as [# of Items], and each record in the Items table looks up the summary field from the parent record as [Purchase Order - # of Items].
In the formula below I use variables because that's much easier than escaping a lot of quotation marks.
// This variable points to the child table, where this formula field resides var text url = URLRoot() & "db/" & [_DBID_ITEMS]; // The following variable assembles the Quick Base query parameter var text query = URLEncode("{'8'.'TV'.'" & [Related Purchase Order] & "'}"); // The actual formula displays the summary field from the parent table inside a hyperlink that matches the built-in query from the parent table "<a href='" & $url & "?a=s&query=" & $query & "&opts=disprec&isDDR=1'>" & [Purchase Order - # of Items] & "</a>"I hope this is helpful.
PHILLIP DENNIS, CMA
Principal | Watkyn LLC
(954) 900-6690 | www.watkyn.com
