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

Case Example

This chapter contained an example of Cascade Delete Related Records using three tables in the Northwind database. The example was complicated, so instead of having you perform the steps, I gave you a narrative. Now that you understand how Cascade Delete Related Records works, you might like some hands-on experience in this area:

1.
In the copy of the Northwind database you made in the “Cascade Update Related Fields” section, choose Tools, Relationships to display the Relationships window. (If you haven't done that exercise, follow the instructions in step 1 to make a copy of Northwind.mdb.) Note that there is a one-to-many relationship between Categories and Products, as well as a one-to-many relationship between Products and Order ...

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