Need Formula Field to always navigate to report of child records

You can make a URL formula button to run any report.
A report link field is just a built in feature to run a report with one extra filter - that being how the Report Link field is configured, typically but not necessarily where the Record ID# field on the parent matches the field [Related Parent]] on the child record.

So, first step is to make your perfect report with an <ask the user>  for [Related Parent]
Run the report, answer the question and observe the URL.

Now make a formula URL to mimic that URL

URLRoot() & "db/" & [_DBID_of the child table found in advanced properties] & "?a=q&qid=99&nv=1&v0=" & [Record ID#]

So translated that says:
Go to my Realm and then to the child table and run report #99 which has 1 question and the answer to the zeroth question (don't ask me why but computers sometimes like to start to count from zero) is [Record ID#] of the parent record.

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