Select Relationship's Parent Table Dialog

To create a new relationship, you must select a parent table, then select a child table.

select relationship's parent table, described below
Note: The dialogs to select the parent and child tables are nearly identical. In this example, the Select Relationship's Parent Table dialog is used to illustrate the dialog.

Pattern

Use a Pattern to limit the list of database tables in the Select Relationship's Parent Table dialog. After you specify a pattern, click Refresh to redisplay the list based on your criteria. See Use a Pattern for more information.

After you select the parent table and the child table for the relationship, the Relationship Editor is populated with as much meaningful relationship information as possible.

If the parent table has a primary key, the column names and data types of the primary key columns are inserted automatically in the Parent Expression grid column. Processing then continues as follows:

If the parent table does not have a primary key, a blank line is inserted. You can select column names from a list or type the expressions directly.

Note: For information about compatible columns, see Compatibility Rules for Relationships.