How to define relationships between tables in an Access database

Se aplica a: Access 2013Access 2010Microsoft Office Access 2007

Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb or .accdb).
For a Microsoft Access 2000 version of this article, see 304467 .
For a Microsoft Access 97 version of this article, see 304468 .

Summary


This article describes how to define relationships in a Microsoft Access database. The article includes the following topics:
  • What are table relationships?
  • Kinds of table relationships
    • One-to-many relationships
    • Many-to-many relationships
    • One-to-one relationships
  • How to define relationships between tables
    • How to define a one-to-many or one-to-one relationship
    • How to define a many-to-many relationship
  • Referential integrity
  • Cascading updates and deletes
  • Join types

More Information