Merge subdiagrams into a master database diagram (ADP)

Note  The information in this topic applies only to a Microsoft Access project (.adp).

Merge a set of subdiagrams into a master diagram to consolidate multiple diagrams for a large group of tables that are logically related. For example, as you add new modules to an existing application, you can create one diagram for each new module. You can then merge all the diagrams into the master diagram.

1. In the Database window, click Database Diagrams under Objects, click the master database diagram you want to open, and then click Design on the Database window toolbar.
2. Open the subdiagram that you want to merge into the master database diagram.
3. Select Tile Horizontally or Tile Vertically from the Window menu so that both diagrams are visible.
4. In the subdiagram, choose Select All from the Edit menu.
5. Position the pointer on the title bar of one of the selected tables and drag the selection to the master diagram. If your selection contains a table that is already displayed on the master diagram, it will not be duplicated. A diagram cannot contain duplicate copies of a table.
6. Repeat steps 2 through 5 for each subdiagram that you want to merge into the master diagram.

When you consolidate a group of tables into one database diagram by merging subdiagrams into a master database diagram, the layout of the individual subdiagrams is maintained within the master database diagram.