URL button for a linked report

Question

Hello,I have Budgets and&nbsp; Budget Lines Table, 1 Budget has many Budget Lines. (Related ESTIMATE is primary KEY for the Budgets Table, Estimate ID is a foreign key in the Budget Lines Table)Budget Lines has Chart report (id 14), I try to approach URL button in the Budgets table to open the Chart report, related to the particular Budget in the Budget Lines table.my formula is:URLRoot() &amp; "db/" &amp; [_DBID_BUDGET_LINES] &amp; "?a=q&amp;qid=14&amp;rid=" &amp; [Related ESTIMATE]But it shows the report with all Budget Lines.What I do wrong?------------------------------Andrew S------------------------------

markshnier__you · Answer

You need to make a report of Budget lines with an <ask the user> filter which asks for the Related Budget.

Then change your formula to this.

URLRoot() & "db/" & [_DBID_BUDGET_LINES] & "?a=q&qid=14&nv=1&v0=" & [Related ESTIMATE]

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

andrews · Answer

Thanks, it's work perfectly.------------------------------Andrew S------------------------------

Forum Discussion

URL button for a linked report