O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

  • One-to-one relationships require that the key field's value in only one record in your new table matches a single corresponding value of the related field in the existing table. In this case, the key field in your new table must be unique; duplicate ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required