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

Chapter 4. Relationships: Your Key to Da... > Establishing Relationships

Establishing Relationships

Relationships between Access tables are established in the Relationships window, as shown in Figure 4.1. To open the Relationships window, click Relationships on the toolbar with the Database window active or choose Relationships from the Tools menu. In the Relationships window, you can see the type of relationship that exists for each table. All the one-to-many relationships defined in a database are represented with a join line. If referential integrity has been enforced between the tables involved in a one-to-many relationship, the join line between the tables appears with the number 1 on the one side of the relationship and with an infinity symbol on the many side of the relationship.

Figure 4.1. The Relationships window enables you to view, add, modify, and remove relationships between tables.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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