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 ...
Get Special Edition Using Access 97, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
