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:
- Specifies the origin (in A->) and target (in B->) column names.
- Specifies the type of relationship between the columns.
- Specifies if your relationship will be used in the query. Default is checked.
- 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.
- 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.
- Default. Specifies that the data retrieved is common for both tables.