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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.