O'Reilly logo

Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills by Bob Schneider

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

Chapter 4. Establishing Relationships

Although I discussed relationships at length in Chapter 3, “Understanding Relationships,” I didn't show you how to formally create them in an Access database. In this chapter, you will learn how to establish relationships in the Relationships window. I also explain the three key options that are available in the Edit Relationships dialog box: most notably Enforce Referential Integrity, but also Cascade Update Related Fields and Cascade Delete Related Records.

In affairs of the heart, you'll often hear someone say, “I'm currently in a relationship.” Whether the happy couple is in a state of “significant othership” or whether they are merely “erfriends” (as in “Mom and Dad, I'd like you to meet my, er, friend) ...

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