referential integrity

Rules that you follow to preserve relationships between tables when you add, change, or delete records.  Enforcing referential integrity involves prohibiting users from adding records to a related table for which there is no primary record, changing values in a primary table that would result in orphan records in a related table, and deleting records from a primary table when there are matching related records.