Edit an existing relationship (MDB)

Microsoft Office Access 2003

Show All Show All

Edit an existing relationship (MDB)

Note  The information in this topic applies only to a Microsoft Access database (.mdb).

  1. Close any tables you have open. You can't modify relationships between open tables.
  2. Press F11 to switch to the Database window.
  3. Click Relationships Button image on the toolbar.
  4. If the tables whose relationship you want to edit aren't displayed, click Show Table Button image on the toolbar and double-click each table you want to add.
  5. Double-click the relationship line for the relationship you want to edit.
  6. Set the relationship options.