MS Access

Understanding Relationship Types

The Edit Relationships dialog box indicates the type of relationship that exists between two tables.

When you link two tables together, they form one of three possible relationships, as shown in figure. This information is rather technical, but it's good to know if you're working with related or linked tables. There isn't a step-by-step exercise in this lesson all you have to do is look over table to get a better understanding of table relationships.

Types of Relationships
Relationship Description

Each record in a table relates to one record in another table. This is the simplest type of relationship, but it doesn't occur very often because it's usually easier to store such information in one table instead of two.

Example: Each customer has one credit report.

Each record in a table relates to one or more records in another table. This is the most common type of relationship.

Example: Each customer has one or more invoices.

One or more records in a table relate to one or more records in another table. Many-to-many relationships are very confusing and thus aren't used very often. To create a many-to-many relationship, you usually need a third intermediate table that contains the primary keys from each of the two tables in the relationship. Such an intermediate table is called a junction table.

Example: Each sales representative sells several products, and each product is sold by several sales representatives.


by BrainBellupdated
Advertisement: