Forum Discussion
QuickBaseCoachD
9 years agoQrew Captain
You will need to relocate the effect of a Report Link field which has the concept of filtering only record for the related parent.
To do that make a report with an <ask the user> for related parent. Run he report, answer the question of. With the record ID if any parent and and observe the URL. We need to replicate that URL.
The formula will be
URLRoot() & "db/" & [_DBID_of the child table with the ask the user report that you get from the Table's Advanced Properties] & "?a=q&qid=99&nv=1&v0=" & ToText([Related Parent]
Replace the 99 with the report number you see in hat URL when you ran the report, and for [Related Parent] use the reference field in the Relationship which ties the children back to the Parent.
To do that make a report with an <ask the user> for related parent. Run he report, answer the question of. With the record ID if any parent and and observe the URL. We need to replicate that URL.
The formula will be
URLRoot() & "db/" & [_DBID_of the child table with the ask the user report that you get from the Table's Advanced Properties] & "?a=q&qid=99&nv=1&v0=" & ToText([Related Parent]
Replace the 99 with the report number you see in hat URL when you ran the report, and for [Related Parent] use the reference field in the Relationship which ties the children back to the Parent.