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) ...
Get Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills 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.
