Hyperlinking Field to Original Table
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 int...
Forum Discussion
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.
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.