Create One-To-Many Relationships Dialog Box

See Also

Establishes a one-to-many relationship, in which the child table can contain multiple records that correspond to one record in the parent table. Corresponds to the SET SKIP command.

This dialog box appears when you choose the 1-To-Many button in the Data Session window.

The 1-To-Many button is enabled when there is at least one relation originating from the selected table.

Dialog Box Options

Child Aliases

Lists the child aliases of the parent alias, whose name is given at the top of the dialog box.

Selected Aliases

Lists aliases of all tables currently involved in a one-to-many relationship with the parent table.

Move

Copies the selected child aliases in the Child Aliases box to the Selected Aliases box. To enable this button, you must select an alias in the Child Aliases box.

All

Copies all the child aliases in the Child Aliases box to the Selected Aliases box.

Remove

Removes the selected aliases from the Selected Aliases box. To enable this button, you must select an alias in the Selected Aliases box.

Remove All

Removes all aliases from the Selected Aliases box.

For more information, see Chapter 2, Creating Tables and Indexes, in the User's Guide.