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 YouTubes can be found at: https://learncs.w3spaces.com/
Thanks, Lisa Friedrichsen
Видео Microsoft Access A to Z: Enforcing Referential Integrity on Table Relationships канала Lisa Friedrichsen
All of my YouTubes can be found at: https://learncs.w3spaces.com/
Thanks, Lisa Friedrichsen
Видео Microsoft Access A to Z: Enforcing Referential Integrity on Table Relationships канала Lisa Friedrichsen
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Basics of Web Design - Chapter 2: HTML BasicsJavaScript I final project examples - Lisa Friedrichsenjavascript.info The Modern JavaScript Tutorial Part 2: 4.2 Focusing: focus/blurJavaScript Chapter 5 debriefCoding Bootcamp 101: What you need to know before spending $10K -- Introduction to CSSPublishing to the JCCC student web serverjavascript.info The Modern JavaScript Tutorial Part 2: 1.6JavaScript Shopping Cart -- Part 2The best web development and JavaScript ResourcesBasics of Web Design Chapter 12: Web Publishing Basicsjavascript.info The Modern JavaScript Tutorial: Syntax reviewMicrosoft Access: Analyzing table relationships in the Nutrition tracking templateJavaScript Web Warrior textbook Chapter 2 Hands on Project 2-4 debriefHTML 5 habits and terminologyMicrosoft Access: The error message "Some Data May Be Lost" - calculating the length of a text fieldMicrosoft Access: Fixing the #Name? ErrorMicrosoft Access: Troubleshooting a query that selects too many recordsIntroduction to CSS cascading style sheetsMicrosoft Access Tip -- Access and database terminology by Lisa Friedrichsenjavascript.info The Modern JavaScript Tutorial 1.2 Code Editorsjavascript.info The Modern JavaScript Tutorial Part 2: 1.5 Node properties