Examining Indexes and Relationships
The field that joins two tables on the one side of a one-to-many relationship must be a primary key field or must have a unique index so that referential integrity can be maintained. If the index on the one side of the relationship is not unique, there is no way to determine to which parent a child record belongs. It is also necessary for you to create an index for the field on the many side of the relationship. If you fail to do this, the performance of the application suffers.
Get Alison Balter's Mastering Access 2002 Enterprise Development 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.
