A script-enabled browser is required for this page to function properly.

Set Relationship dialog box

The Set Relationship dialog box enables you to create simple, self, composite, unmatched, and non-equal relationships between two tables.

Note:   Although you can set relationships using this dialog box, you should use the mouse method to create relationships wherever possible. For relationships created this way, Query Builder automatically activates and deactivates the relationship lines for you.

This dialog box contains:

Relationship

Specifies the origin (in A->) and target (in B->) column names.

Operator

Specifies the type of relationship between the columns.

Use Relationship in Query

Specifies if your relationship will be used in the query. Default is checked.

A not found in B

Specifies that the data retrieved is all data common to both tables, in addition to data that is in table A, but not in table B.

B not found in A

Specifies that the data retrieved is all data common to both tables, in addition to data that is in table B, but not in table A.

Suppress Mismatches

Default. Specifies that the data retrieved is common for both tables.

 

See also

Creating a simple relationship (Query Builder)