Adding Detail and Lookup Tables
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.
When you add a main table to the table hierarchy, all related detail and lookup tables are added automatically to the hierarchy. However, if you make schema changes to your database, new related tables are not added to the hierarchy automatically. Add these tables to the hierarchy manually if you must have them for workflow.
Note To add a table to the hierarchy, the table must exist already in the database.
To add a detail or lookup table to the table hierarchy
Open your database in Microsoft® Office XP Developer.
Select the Project node in the Solution Explorer.
Open the Project menu, and click Add New Item.
Double-click the Add a Detail Table or Add a Lookup Table icon in the Add New Item dialog box.
Select the detail or lookup table from the list.
Note If the table you select is not related to the main table, the OK button is made unavailable.
Click OK.
See Also
Defining Hierarchy Schema | Creating a Table Hierarchy | Removing User Tables