Forum Discussion

JakeRattner1's avatar
JakeRattner1
Qrew Cadet
3 years ago

Code Page: Embedded Child Table Recieving Error

Hi QB Community, 

I'm looking to bring a table of child records into a form using a code page. I need to add arguements and options which don't seem possible going off the default report (ex. ~bids~ )

My Query looks something like this (I've replaced table ID):
~=qdb.GetURL("TABLE ID", "API_GenResultsTable^query={'70'.EX.'"+ field["Record ID#"]+"'}")~

Or this query
 
~=qdb.GetURL("TABLE ID", "API_GenResultsTable^query={'70'.EX.'"+ field["Record ID#"]+"'}^clist=1.2.3.4.^options=nvw.ned.phd.nfg.sortorder-A^slist=25");~

The result is this message: 
Invalid Table
 
This operation is only supported on individual tables and not on the application itself. Please check the URL.


The other merge fields in the form work correctly, so it seems to have to do with the Child table although it also sounds like the problem is the URL.  Does anyone have an idea of what might be going on here?

Thanks!

------------------------------
Jake Rattner
------------------------------
  • Have you double checked that the TABLE ID is correct?

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • JakeRattner1's avatar
      JakeRattner1
      Qrew Cadet
      You're absolutely right!  It seems painfully obvious now.  Thanks you very much