Hyperlinking Field to Original Table

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
Hyperlinking a field  when summed from a child table is a great option to allow user to drill down. In my situation I have a summary field from table A in the parent table.   As this info is quite interesting I have also chosen to share this with table B by passing it down from parent table.  Issue is that when user clicks on the hyperlink they are taken back to project screen.  Is there a possibility that we could allow user to go to Table A instead?   
Photo of Arshad Khwaja

Arshad Khwaja

  • 3,152 Points 3k badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Just to close the loop on this one.  I spoke to Arshad directly.  The issue was that the numerical field was a lookup from a parent record of a summary field.  Clicking that "number", just opened up the Parent record, and did not do the drill down.

So a quick and dirty solution was to change that number so it did not appear "as a link to the Record", and put a button beside it with this code

URLRoot() & "db/" & [_DBID_CHILD_TABLE FOR DRILL DOWN]& "?a=q&qid=10&nv=1&v0=" &[Related Project]

So it will run that report, ask a question and answer its own question and display the drill down results.
... ie this was an <ask the user> report with 1 question.