Create Relationship Page
Specify the parent and child relationships to use in the SQL statement.
Element | Description |
---|---|
Parent Table |
Select the parent table. |
Child Table |
Select the child table. |
Mapping Type |
Select the mapping type (one-to-many, one-to-one, or one-to-one with the foreign key on the child table). For example, if you selected Employees as the parent table and Departments as the child table, the following options are displayed:
|
Parent and Child Table |
Associate the foreign key fields to the primary key fields. |
Relationship Name |
Optionally name the relationship (a default name is generated). |