Chapter 4. Relationships: Your Key to Data Integrity

Understanding Relationships

A relationship exists between two tables when a key fields from one table is matched to a key fields in another table. The fields in both tables usually have the same name, data type, and size. Relationships are a necessary by-product of the data-normalization process. Data normalization is covered in Chapter 1, “Introduction to Access Development;” it is the process ...

Get Alison Balter's Mastering Access 97 Development, 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.