Adding Detail and Lookup Tables

See Also

When you add a main table to the table hierarchy, all related detail and lookup tables are automatically added to the hierarchy. However, if you make schema changes to your database, new related tables may not be added automatically to the hierarchy.

It is advantageous to add these tables to the hierarchy if you want to include them in offline publications or add core services to them.

Table icon	Table type
	Lookup table
	Detail table

To add a table to the Access Workflow Designer hierarchy, the table must already exist in the database. Access Workflow Designer creates only helper tables associated with core features, such as workflow and offline publications.

Note   After making database schema changes, you must re-create an existing offline publications, see Re-creating an Offline Publication.

To add a detail table to the table hierarchy

1. In the Access Workflow Designer, expand the Tables node in the Object List. To see the detail or lookup tables, expand the main table nodes.
   
   
2. In the Object List, select a table.
   
   
3. On the Edit menu, point to Insert, and then click Add detail table.
   
   
4. In the Add Detail Table dialog box, select the related table from the list.

   Note   If the table you select is not related to the main table, the OK button is disabled.

5. Click OK.

To add a lookup table to the table hierarchy

1. In the Access Workflow Designer, expand the Tables node in the Object List. To see the detail or lookup tables, expand the main table nodes.
   
   
2. In the Object List, select a table.
   
   
3. On the Edit menu, point to Insert, and then click Add lookup table.
   
   
4. In the Add Lookup Table dialog box, select the related table from the list.

   Note   If the table you select is not related to the main table, the OK button is disabled.

5. Click OK.