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

Chapter 19. Taking Advantage of Database... > Viewing Related Records in the Datas...

Viewing Related Records in the Datasheet View

When working with a table in the Datasheet view, you can view data held in a related table. The information that can be viewed is contained in any table that is subordinate to the table you currently have open in the Datasheet view. Tables subordinate to a particular table hold the foreign key (which is the primary key in the top-level table in the relationship).

For example, suppose you are viewing the Departments table that was included in the table relationships shown in Figure 19.1. A plus sign appears to the left of each record in the table (see Figure 19.3). To view related data for each record, click the plus sign. A table appears that contains the related data for that record. In this example, the Employees table provides the related data (which, if you look back at Figure 19.1, was related subordinately to the Departments table).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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