Creating a Table Hierarchy
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
After you have determined which tables to include in the table hierarchy (those tables that have workflow, have row-level permissions, or serve as a the record source for a data access page), you are ready to set up your table hierarchy.
To set up your table hierarchy
In the Access Workflow Designer, open your team solution. For details about opening the designer, see Accessing Access Workflow Designer Tools.
On the toolbar, select Add Main Table to open the Main Table Selection wizard.
Specify which tables are main tables. For details, see Identifying Main User Tables.
Add any other detail or lookup tables to the hierarchy. For details, see Adding Detail and Lookup Tables.
To view the table hierarchy
In the Access Workflow Designer, expand the Tables node in the Object List.
To see the detail or lookup tables associated with the main tables, expand the main table node.
| For information about | See |
| Modifying the table hierarchy and row-level security and specifying additional main tables | Identifying Main User Tables |
| Creating new detail and lookup tables | Adding Detail and Lookup Tables |
| Specifying read/write permissions for each role | Defining Table Security |
| Adding row-level security to your team solution | Enabling Row-Level Permissions |