• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 37. Customizing Tables, Forms, a... > Defining Relationships Between Table...

Defining Relationships Between Tables

A well-designed Access database typically contains many interrelated tables, with each table containing a specific, narrowly defined set of data, without any duplicate information. This type of design is crucial to maintaining referential integrity—when you change a name, address, or other piece of data in one record, your change automatically appears in all related tables.

Imagine a database application that tracks customer purchases based on invoices. A proper design stores this information in four separate tables, as shown in Figure 37.2:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint