10 Things You Need to Know About Relationships in Access 2013
Enforce referential integrity in the Edit Relationships dialog to prevent orphan record entry in the child table.
An orphan is a record in the child table that doesn’t have a corresponding record in the parent table. The classic example is an order in an Orders table for a customer not in the Customers table. Referential integrity prevents entering these kinds of orphan orders.