Configuration Guide

10.5

Back Next

Selecting Additional Tables

When you created the generic query, you selected the primary table that you want to query. When you edit the query, you can add additional tables. You can also define foreign key relationships between the tables.

If you intend to use a query with an update package, do not select additional tables. The purpose of an update package is to update the data in the primary table.

In the properties pane, click the

Tables

tab.

Click the

Add

icon.

If the Add icon is not available, the query is associated with an update package. Update packages can reference only one table.

In the

Select table to add

dialog box, select the table and click

The table appears in the view area and in the list. In the list, the Join Type is Cross.

Optionally, create a foreign key relationship between the tables:

In the view area, find the columns that you want to relate. The columns must be compatible for a join.

From a circle beside one column, drag a connector line to a circle beside the other column.

In the list, the Join Type changes to Inner.

Optionally, change the Join Type by selecting a type from the list.

When a query contains more than one relationship, only one of the relationships can be an outer join.

Add other tables as required.

If you add a table or relationship in error, you can remove it.

Option	Description
Remove a relationship	In the view area, right-click the connector line, and click Delete .
Remove a table	In the view area, select the table, and click the Delete icon. You cannot delete the primary table.