Question: what is referential integrity in access?
Answer: Referential integrity in table relationships keeps users from accidentally deleting or changing related data. You can apply referential integrity when: the common field is the primary table's primary key; the related fields have the same format; or both tables belong to the same database.