Adds a detail table to the selected main table from a list of all tables not already marked as main or detail tables. For details, see Adding Detail and Lookup Tables.
A new detail table is automatically added to any publication in which its parent has been published. You may be required to re-create the publication.
Note When you add a table to Access Workflow Designer, it may not appear until you refresh the Object List or close and then reopen the Tables pane.
Parent table
Type or select the parent table to which you want to add this detail table. The parent table must have been added to the table hierarchy as a main or detail table.
If you opened this dialog box by right-clicking a table in the Object List, the name of that table is read-only in the Parent table field. If you open this dialog box from the Edit/Insert menu options, you can select the parent table from a list of main tables.
Detail table
Select a table from the database as the detail table. To specify a detail table, the table must already exist in the database.
Related Columns
Displays the foreign key constraint that relates the detail table to its parent. A detail table must have a one-to-many foreign key relationship with the parent table.
Parent table
Displays the columns in the parent table used in the foreign key constraints.
Current table
Displays the column in the current detail table used in 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 |