Filter
Top Products
query selected.
For mapped queries only ACCOUNTREFERENCE and blank are available.
The Parent Table for Ad Hoc queries may be ACCOUNTREFERENCE or any of the
previously defined data queries. When the parent table is a previously defined data
query the results of the current query will be displayed as a child table in the data viewer.
If the parent table selected is another data query the parent/child relationship must be
created. The parent child relations define how the parent table is related to the current
query.
Relationships – This grid defines the parent and child fields that create the relationship between
the Parent
Table and the current query. The Add button allows the user to add a new row to the
grid, and the
Del button deletes the currently selected row from the grid.
Test – Allows the user to test the query.
Views – Allows the user to add ERP System views to the selected query data. ERP System
views are
described in the next section.
Page 31 of 45