Detail Table General Tab (Tables Pane)

See Also

Displays information about the table and its relationship to the parent table in the hierarchy.

A detail table contains additional data related to the rows in its parent table. It must have a one-to-many foreign key relationship with its parent table. If you change the constraint that relates the detail table to its parent, you must update the information shown in the designer by clicking the Find Foreign Key button.

Options

Base View

Displays the base view of the selected detail table. The base view is used to enforce row-level permissions. All data access to the detail table must be made through this view. Read-only.

Workflow Process

Displays the name of the workflow process associated with the detail table. To add a workflow process, use the Workflow Process wizard. Read-only.

Parent table

Displays the name of the parent table. Read-only.

Relationship

Displays the foreign key constraint that relates the detail table to its parent table. Read-only.

Parent table column

Displays the column in the parent table that is used in the foreign key constraint.

Current table column

Displays the column in the selected table that is used in the foreign key constraint.

Find Foreign Key

Select to identify or update the foreign key relationship that relates the table to its parent table. This option updates the relationship if you have changed, added, or removed the foreign key constraint.

Where to go from here

For information about See
Defining a table hierarchy for your solution database Setting up a Table Hierarchy
Adding and removing detail and lookup tables in the Tables node Adding Detail and Lookup Tables
Selecting main tables for your solution Identifying Main User Tables
Setting up table and row-level permissions for your main tables Defining Table Security
Adding a workflow process to your solution Building a Workflow Process
Creating offline publications for your solution Allowing Users to Work Offline