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.
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.
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 |