User`s guide

Often, data in two different tables can be related by a common field. For example, a Customers table
will have a Customer ID for each customer, and an Orders table will have the Customer ID of each
customer who placed an order, demonstrating a relationship between tables. The two tables can be
linked by a common field see Linking tables.
The following diagram displays how two tables can have a relationship:
23.1.2 Indexed tables
2012-03-14504
Understanding Databases