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

Chapter 9. Creating Relationships Betwee... > Understanding Table Relationships

Understanding Table Relationships

You've already learned in Lesson 1, “Working in Access,” that the best way to design a database is to create tables that hold discrete types of information. For example, one table can contain customer information, and another table can hold order information. By creating relationships between tables, you make it possible to combine information from the tables into forms, queries, and reports to produce meaningful results.

Suppose that you have two tables in your database. One table, Customers, contains names and addresses; the other, Orders, contains orders the customers have placed. The two tables both contain a common field: Customer ID. All records in the Orders table correspond to a record in the Customers table. (This is called a one-to-many relationship because one customer could have many orders.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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