Using a Child Report in an Exact Form that references Parent

Ok, so according to many posts here on the forum, you have to choose between embedding a child report, and having a report that is related to a Parent (aka only shows records related to the Parent Record ID#)

I personally love to make native reports with custom column headings, that can be used in multiple places, and be changed in one place natively.

So just take the following steps:

1. Make a native report with all of your filters, header over-rides, groupings, etc
2. Make one of your report filters [Related Parent (Record ID#)] is equal to 'ask the user'
3. Put the following code into your Exact Form where you want the table to show up:

~=qdb.GetURL("bqxx2xx2s","API_GenResultsTable^qid=11^query={'9'.EX.'"+field["Record ID#"]+"'}^options=nos.qws.&nv=1&v0='"+field["Record ID#"]+"'");~

Let's break that code down:
~=qdb.GetURL("CHILD TABLE ID FROM URL","API_GenResultsTable^qid=THE NUMERICAL ID OF THE CHILD REPORT^query={'NUMBER OF THE FIELD IN THE CHILD TABLE THAT RELATES TO THE PARENT RECORD ID#'.EX.'"+field["Record ID#"]+"'}^options=nos.qws.&nv=1&v0='"+field["Record ID#"]+"'");~
v0 means "variable 0" it is the part of this string that references the 'ask the user' part of the report. You can add other 'ask the user' filters on your report if you need to, but try and make the Related Parent one the first.

------------------------------
QuickBase Girl
------------------------------