Microsoft Office Tutorials and References
In Depth Information
Relationships sit at the very heart of what distinguishes a
database from a worksheet; a relationship is a rule that cannot be
subverted when you are entering or changing data and
guarantees the consistency of your data (within the bounds of the
rules). The relationship diagram can be a very misleading tool to
work with in any database because it serves two purposes.
diagram without changing anything. It is a passive picture that
helps you see how tables are related to each other.
The second role of the diagram is exactly the opposite of the
first use. When it comes to the actual relationships between
tables (the lines joining them), the diagram is an active tool that
allows you to create and delete rules (relationships) between
First, it is a roadmap you can delete tables and queries from the
1 Click the Database Tools tab.
2 Click Relationships.
3 Double-click a relationship line to display and/or change the
TIP If you have a lot of tables on the relationship diagram,
you can hide them all from the diagram and add just one table
of interest to the diagram. Then, selecting that table and clicking Direct
Relationships (in the Design tab of the ribbon) will display only those
relationships between the selected table and other tables in the
database. This is a very useful feature when you have a complex
database with a large number of tables.