Add labels to relationship lines in a database diagram (ADP)

Microsoft Office Access 2003

  1. Right-click the database diagram.
  2. From the shortcut menu, choose Show Relationship Labels.

ShowRename relationship labels

  1. Select the relationship line you want to rename.
  2. Right-click the relationship line and select Properties from the shortcut menu.
  3. Select the Relationships tab.
  4. In the Relationship name box, type a new name for the relationship label.

Note   You cannot change the font for relationship labels.

If relationship line labels are not displayed, you can still see the relationship line label for a given relationship.

ShowView a label for a specific relationship line

  1. In the database diagram, move the mouse over the relationship line.
  2. The Tooltip will show the relationship label.