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

Chapter 26. Database Primer > Creating Relationships Between the Tables

Creating Relationships Between the Tables

Now that you've created all the tables and columns within the database, you are ready to begin creating the relationships. Remember, relationships are what make the database efficient and keep you from duplicating data within individual tables. To begin establishing relationships between tables, follow these steps:

1.
From the Tools menu, select Relationships.

2.
When you are prompted with the Show Table dialog box, add every table by selecting the first table, holding down the Shift key, and then selecting the last table. Click Add.

3.
Choose Close.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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