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

Chapter 4. Working with Access Databases... > Working with Relations, Key Fields, ...

Working with Relations, Key Fields, and Indexes

Your final tasks before adding records to the Personnel Actions table are to determine the relationship between Personnel Actions and an existing table in the database, assign a primary-key field, and add indexes to your table.

Establishing Relationships Between Tables

Relationships between existing tables and your new table determine the field used as the new table's primary key. The following four possibilities exist for relationships between tables:


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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