Removing a Relationship | 10 Minute Guide to Microsoft Access 2002


Team-Fly

	10 Minute Guide to Microsoft Access 2002 By Joe Habraken
	Table of Contents

	Lesson 11. Creating Relationships Between Tables

Removing a Relationship

To delete a relationship, just click it in the Relationships window (the line between the tables turns bold to indicate that it is selected), and then press Delete. Access asks for confirmation; click Yes, and the relationship disappears.

If you delete relationships between tables, you are affecting how information in the tables can be combined in a query, form, or report. It is a good practice to design your tables so that they can be related. Re member that each table is supposed to hold a subset of the database information. If each table is set up correctly, it should have at least one other table in the database to which it can be related .

In this lesson, you learned how to create, edit, and delete relationships between tables. In the next lesson, you learn how to create forms using a wizard or from scratch.


Team-Fly

Top