Homework SourseIf you add Enforce Referential Interity to a relationship wh
If you add Enforce Referential Interity to a relationship when you add a record to a related table, a matching record must already exist in the primary table, thereby preventing the possibility of orphaned records. True or False?
If you add Enforce Referential Interity to a relationship when you add a record to a related table, a matching record must already exist in the primary table, thereby preventing the possibility of orphaned records. True or False?
Solution
True.
As Referential integrity rules prevent the creation of orphan records in the table on the many side of the one-to-many relationship. But following conditions must be met: The matching field on the one side of the relationship must be a Primary Key field or must have a unique index, the matching fields must have the same data types.
