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:
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
------------------------------
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
------------------------------
