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

Why Create Relationships?

Lesson 2 encourages you to make separate tables for information that's not directly related. When you create forms, queries, and reports, you can pull information from more than one table easily. But this works best when an appropriate relationship has been defined between the tables.

Suppose that I had two tables containing information about my customers. One table, Customers, contained their names and addresses; the other, Orders, contained their orders. The two tables would have a common field: Customer ID. All records in the Orders table would correspond to a record in the Customers table. (This is called a "one-to-many" relationship because there could be many orders for one customer.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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