Chat with us, powered by LiveChat

Create Relationships Between Tables

How to Create Relationships Between Tables in Access

Create Relationships Between Tables

Once you begin to understand the concept of relational databases, the process of actually linking the tables in a database is rather simple.

Rules for Linking Two Tables

Make sure you keep these rules in mind when you link to tables together:

  • Linked fields should be (almost) identical.
  • Related fields must have the same data type and field size and must contain the same kind of information.
  • The primary key in one table is usually linked with a matching field in the other table.
  • Fields related to an AutoNumber primary key field must be Number fields with the Long Integer Field Size.
    Rules for Linking Two Tables

Create Relationships Between Tables

You need to display the Relationships window in order to view and create relationships between tables.

  1. Click the Database Tools tab.
  2. Click the Relationships button.
    Create Relationships Between Tables
  3. Click the Show Table button.
  4. Double-click the table(s) you want to add.
  5. Click Close.
    Create Relationships Between Tables
  6. Click the related field in the first table and drag it to the related field in the second table.

    Whenever you link a primary key from one table to a field from another table, you create a foreign key.

    Create Relationships Between Tables
  7. Check the Enforce Referential Integrity option (optional).
  8. Referential integrity helps you avoid “orphan” records and maintains database accuracy.

  9. Click Create.
    Create Relationships Between Tables

The two tables are now linked, indicated by the line linking the two related fields.

FREE Quick Reference

Click to Download