Previous Topic: Specify an Author for a Diagram

Next Topic: Override Font and Color for a Shape

Select Members for a Diagram

When you create a new ER diagram, ERwin always creates a blank diagram. You must select members for the diagram.

To select members for a diagram

  1. Click Diagrams on the Diagram menu.

    The Diagram Editor opens.

  2. From the Edit ER Diagrams in drop-down list, select the model or subject area that has the diagram for which you want to select members.

    The diagrams available in the selected model or subject area are displayed.

  3. Select the diagram for which you want to select members, and then click the Members tab.
  4. Select a diagram from the Name list to which you want to add members, use any combination of the following options, and then click Close.
    Available Objects

    Displays objects that you can include as members of the selected diagram. Select one of the following options to include members to the diagram:

    Move selected objects to Included Objects ()

    Moves the selected objects to the Included Objects section.

    Move all objects to Included Objects ( )

    Moves all the objects in the Available Objects section to the Included Objects section.

    Move selected objects and neighboring objects to Included Objects ()

    When you select an object that you want to include in the diagram and click this icon, opens the Spanning Neighborhood dialog. Make your selections for the following options:

    Ancestors

    Specifies the number of ancestors to include in the diagram. Ancestors are the parents of an entity. Select All or select Level and enter the number of ancestors to include. Consider the following example:

    Illustrating an example for ancestors and descendants

    In this example, if you select Table _C and enter 2, the parent of Table_C, which is Table_B (level 1) and the parent of Table_B, which is Table_A (level 2) are included. If you select View_A and enter 2, only Table_A is included.

    Descendants

    Specifies the number of descendants to include in the diagram. Descendants are the children of an entity. Select All or select Level and enter the number of descendants to include. In the previous example, if you select Table_A and enter 2, the children of Table_A, which are Table_B and View_A (level 1) and the child of Table_B, which is Table_C (level 2) are included.

    Include all objects contained in another diagram

    Opens the Diagram Editor. From the Include all objects contained in list, select the diagram from which you want to include objects.

    Included Objects

    Displays objects that are currently included as members of the selected diagram. Select one of the following options to remove members from the diagram:

    Automatically populate with all model objects

    Displays all the objects in the current model in the Included Objects section.

    Move selected objects to Available Objects ( )

    Remove the selected objects from the Included Objects section and moves them to the Available Objects section.

    Move all objects to Available Objects ()

    Removes all the objects from the Included Objects section and moves them to the Available Objects section.

    Move selected objects and neighboring objects to Available Objects ()

    When you select an object you want to exclude from the diagram and click this icon, opens the Spanning Neighborhood dialog. Make your selections for the following options:

    Ancestors

    Specifies the number of ancestors to exclude from the diagram. Select All or select Level and enter the number of ancestors to exclude.

    Descendants

    Specifies the number of descendants to exclude from the diagram. Select All or select Level and enter the number of descendants to exclude.

    Remove all objects contained in another diagram

    Opens the Diagram Editor. From the Remove all objects contained in list, select the diagram from which you want to remove objects. The objects are removed from the current diagram.

    Edit the Selected Object (erw_hlp--Edit Object--ICO)

    Opens the object editor dialog so that you can edit the selected object.

Include Objects from Another Diagram

If you have diagrams for specific sections of a model, you can include objects from one diagram into another.

To include objects from another diagram

  1. Click Diagrams on the Diagram menu.

    The ER Diagram Editor opens.

  2. Click the Members tab.

    The Members tab opens.

  3. Click the Include all objects contained in another diagram (Remove object from another diagram icon) icon.

    The ER Diagram Editor appears.

  4. From the Include all objects contained in drop-down list, select the Diagram from which you want to include the objects, and click OK.

    All the objects in the diagram except shapes, appear in the Included Objects section of the Members tab.

    Note: The Include all objects contained in another diagram option includes only model objects and not drawing objects.

    To remove the objects included from another diagram, click the Remove all objects contained in another diagram icon (Include object from another diagram icon).

    All the objects that are part of another diagram are removed from the Included Objects section and displayed in the Available Objects section.

  5. Click Close.

    The selected diagram objects are added to the current diagram in the same position as in the original diagram. If the diagram had objects before you used this option, you may find the new objects overlap with the existing ones.

Sort Options

You can sort the diagram or subject area members in the Available Objects and the Included Objects sections. The toolbar in these sections has the following sort options:

property editor SORT icon

Specifies that the list is sorted in alphabetic order of the name of the object.

Property editor Reverse Alpha Sort Button

Specifies that the list is sorted in reverse alphabetic order of the name of the object.

Sort

Specifies that the list is sorted in the alphabetic order of the owner of the object, and then the name of the object.

Sort

Specifies that the list is sorted in the reverse alphabetic order of the owner of the object, and then the name of the object.

Display Name Format Options

You can display the name of the diagram or subject area members in various formats in the Available Objects and the Included Objects sections. The toolbar in these sections has the following options:

erw_hlp--Bulk Editor Wizard Object Types Toolbar - Names

Opens a menu so you can select to show object names as either logical names or physical names. When you select one of the options, the toolbar button changes to provide you a visual indication of your choice:

erw_hlp--Bulk Editor Wizard Object Types Toolbar - Logical Names--SCR Logical Names
erw_hlp--Bulk Editor Wizard Object Types Toolbar - Physical Names
erw_hlp--Bulk Editor Wizard_Obj Sel Page_Phys Names Show Owner--SCR Physical Names, show owner
erw_hlp--Bulk Editor Wizard_Obj Sel Page_Phys Names Show Owner Using User--SCR Physical Names, show owner using User

Note: The Logical Names option does not display if you are working in either a logical-only or physical-only model.