Add Lookup Table Dialog Box

See Also

Adds a lookup table and relates it to a main or detail table in the Object List. For details, see Adding Detail and Lookup Tables.

A new lookup table is added automatically 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 Main/Detail Tables

Displays a list of main and/or detail tables to which the lookup table can be related.

Lookup Table

Displays a list of tables in the database that are not already marked as main or detail tables.

Note   The OK button is enabled only when you select two tables that already have a foreign key relationship defined in the database.

Where to go from here

For information about See
Defining a table hierarchy for your solution database Setting up a Table Hierarchy
Selecting main tables for your solution Identifying Main User Tables
Setting up table and row-level permissions for your main tables Defining Table Security