For more information, see Guide to table relationships and Get started with table relationships.
A relationship can also help prevent missing data, by keeping deleted data from getting out of synch, and this is called referential integrity.īefore you work with relationships, make sure you understand the background concepts. When you use related tables in a query, the relationship lets Access determine which records from each table to combine in the result set. Each record in the OrderDetails table has a ProductID that corresponds to a record in the Products table with the same ProductID.
For example, you might have a ProductID field in a Products table and in an OrderDetails table. Each relationship consists of fields in two tables with corresponding data.
A relationship in Access helps you combine data from two different tables.