Ten 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.