Add Detail Table Dialog Box

See Also

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.

Options

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.

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