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: Employees has a 1:1 Relationship with Departments Employees has a 1:1 Relationship with Departments (Foreign Key on Child table) Employees has a 1:M Relationship with Departments
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).