Microsoft Access A to Z: Enforcing Referential Integrity on Table Relationships

This short screencast explains the how and why of enforcing referential integrity on one-to-many relationships between two tables in Microsoft Access using the Relationships window. It discusses parent and child tables and how referential integrity prevents the creation of new orphan records in the "many" table as well as the deletion of parent records in the "one" table. It also shows the how and why of using the Cascade Update Related Fields and Cascade Delete Related Records options when referential integrity is enforced. Finally, it presents a word of caution about null values in existing foreign key fields of the child table when referential integrity is applied.
All of my TH-cams can be found at: learncs.w3spaces.com/
Thanks, Lisa Friedrichsen

[@owenwaldo]

you have amazing teaching skills. really helpful that you teach, then state a short summary of each item we learned about

[@lfriedrichsen]

Thank you!

[@FirstLast-cb2jr]

Thanks. This video gives a clear explanation.

[@lfriedrichsen]

Ty! See all my TH-cams organized at learncs.w3spaces.com

[@jerzykepinski]

This is good stuff. Thanks!

[@lfriedrichsen]

You're welcome!

[@kiranarana7274]

Dear Lisa
Do you have video how to creat the table from bigining
First I need to learn how to creat de table from this video

[@lfriedrichsen]

The third TH-cam in the Microsoft Access A to Z playlist shows how to create tables from scratch: th-cam.com/video/nz99MQpj4RQ/w-d-xo.html