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 ... |
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.
