Share this Page URL

Chapter 14. Understanding Access Projects > Using Database Diagrams - Pg. 525

Understanding Access Projects 525 4. 5. In this dialog box, you can select one or more of the options to verify data or to apply referential integrity. Select the option Enforce Relationships For INSERTs And UPDATEs, and then se- lect Cascade Update Related Fields and Cascade Delete Related Fields if you want to apply referential integrity to this table relationship together with the cascading options. Click OK in the Create Relationships dialog box. Rightclick the background of the Diagram window, and then click Show Relationships Labels. As you can see here, a label that describes the relationship is added to the window: