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