Total grandchild records in a grandparent with drill down

Yes there is!

This code is not tested so let me know if there are any syntax errors.

You probably have a field on questions called [Related Audit], so look that up down to Questions but don't call it [Related Audit] because it isn't directly related, so call it what it is,  which is [Record ID# of Audit]

Then create an <ask the user> report on the nonconformities table, which will ask the user for the [Record ID# of the Audit].   so the filter is where 

[Record ID# of Audit] is <ask the user>

If you run the report manually and answer the question you will observe a suffix of

&nv=1&v0=123. (assuming you input 123 as the [Record ID# of Audit].  so we just need a URL formula that will mimic that URL

It will be a Rich Text field type

var text Words = ToText([# of non-conformaties]); // insert correct field  for # of non-conformnaties

var text URL = URLRoot() & "db/" & [_DBID_NON_CONFORMITIES] & "?a=q&qid=10&nv=1&v0=" & [Record ID#];

// translated it into English that URL says to is go to my realm and then go to the table of nonconformities and the action I want to do is to run a query (which when Quickbase was invented just meant a report), and the report number to run is number 10 (you will adjust this to your report#) and the number of values that the ask the user questions will ask for is just one (nv=1) and the answer to the question 0 (Quickbase sometimes likes starting to count at zero instead of 1) is the Record ID# I'm sitting on (since that is the value that gets looked up down to questions and gets looked up again down to nonconformities).

// insert the correct DBID from the Advanced Settings for the non-conformities table.

// insert the correct report# where the 10 is.

// finally, here is the syntax for the hyperlink

"<a href=" & $URL & ">" & $Words & "</a>"