Microsoft Access: Can't create this relationship and enforce referential integrity

This short screencast explains why the "Can't create this relationship and enforce referential integrity" error message appears and how to fix it. The error message is due to the existence of orphan records in the "many" table in a one-to-many relationship. Finding and fixing those records is essential to database performance, developer productivity, and data integrity.
See all of Professor Lisa Friedrichsen's KZbins for Access, database, HTML, CSS, and JavaScript organized at: learncs.w3spaces.com
Thanks, Lisa Friedrichsen

[@denisea3465]

This was absolutely fabulous! Clear instructions, good easy explanation of why and how, and you and solved my problem. Thank you so much!

[@lfriedrichsen]

What a nice comment, thank you! See all of my KZbins organized at learncs.w3spaces.com

[@mariamhafidh3017]

Wonderful and clear explanation. Loved it!

[@lfriedrichsen]

Thank you! See all of my KZbins organized at learncs.w3spaces.com

[@leethallee6718]

Good one! I have had this before and couldn’t understand how to solve it.

[@lfriedrichsen]

Thanks! See all of my KZbins organized at learncs.w3spaces.com

[@philwiggins9199]

Thanks Lisa, solved a problem for me ....

[@lfriedrichsen]

Great! See all of my KZbins organized at learncs.w3spaces.com

[@justsultan1964]

Thankssss YOU SAVED Meeee!!!!❤❤❤❤

[@lfriedrichsen]

You are very welcome!! See all my KZbins organized at learncs.w3spaces.com

[@loveylovers6162]

Thanks 😊❤️

[@lfriedrichsen]

You're very welcome. See all of my KZbins organized at learncs.w3spaces.com

[@lfriedrichsen]

You're very welcome. See all of my KZbins organized at learncs.w3spaces.com