Binding Queries

To display the results of a master query and a detail query in one report, you must bind the queries together.

For example, assume you have an order number printed at the top of an invoice. In the lower part of the invoice, you want to print all the items ordered. The order number could be the bind value used to link the orders table with the order_items table. Another example can be seen in the Samples folder, where the bind value cust_num is used to connect the master query (Customers) with detail queries (Payments and Orders).

To bind queries, use the mouse to drag query fields from one table to another. You can also click Auto Bind to automatically join table columns for which both the name and the data type are the same. You must bind at least one table column in the master query to a table column in the detail query.

To remove a bind, click on the arrow representing the bind and press the [Delete key]. To remove all the existing binds between the queries, click Remove All.

Note:

Correlation is another operation that binds two queries. It is different from binding in that the main query is linked to a subquery within a single SQL statement.

The difference between a join operation and a bind operation is that joins are between two tables in one query, whereas, binds are between two queries.