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

Set Relationship Dialog

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

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 radio button
button 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 radio button
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 radio button
Default. Specifies that the data retrieved is common for both tables.