Identifying Main User Tables

See Also

Main user tables are database tables that contain the primary information for your team solution in the database. These are typically tables to which you add workflow and row-level security. There can be multiple main tables in a database.

Typically, main tables are associated with detail and lookup tables. These secondary tables provide additional information and links between main tables.

To add a main user table to your team solution

1. In the Access Workflow Designer, right-click the Tables node in the Object List. For details about opening the designer, see Accessing Access Workflow Designer Tools.
   
   
2. Select Add Main Table to open the Main Tables Selection wizard.
   
   
3. Click Next to see the list of tables available in the database.
   
   
4. Select the tables you want to identify as main tables, and click Next.
   
   
5. Select the tables for which you want to enable row-level permissions.

   Note   You can enable and disable row permissions at a later time.

6. Click Next, and then click Finish to identify the selected tables as main tables and to enable row-level permissions.

When you return to the Access Workflow Designer, notice that the screen has changed. The General tab of the Tables pane now displays the properties for the tables.

You can enable and disable row-level permissions from this pane. For details, see Enabling Row-Level Permissions.

Detail and lookup tables associated with the main table are automatically added to the hierarchy. The Main Table Selection wizard deduced these from defined foreign key relationships in the database. If they are not displayed in the Object List, you can expand the view under the Tables node or refresh the Tables pane.

For details about adding tables manually, see Adding Detail and Lookup Tables.