Here, the related table contains a foreign key value that doesn’t exist in the primary key field of the primary table. This has resulted in an “orphaned record”.