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 KZitems for Access, database, HTML, CSS, and JavaScript organized at: learncs.w3spaces.com
Thanks, Lisa Friedrichsen
Негізгі бет Ғылым және технология Microsoft Access: Can't create this relationship and enforce referential integrity
Пікірлер: 8