| A | B |
|---|
| Cascade delete | When a record in a parent table is deleted, Access deletes all the related records from the child table where the value from the primary key matches the value in the foreign key. |
| Cascade update | When the primary key field is updated in a relationship, the corresponding foreign key value in the child table's related records automatically updates. |
| Child field | Related field from the child table of the relationship. |
| Child table | The second table of a relationship. When creating a relationship, this is generally the "many" side of the relationship. |
| Foreign key | A field in the child table that is related to the primary key in the parent table. |
| Master field | The related field from the parent table of the relationship. |
| One-to-many relationship | A relationship in which the value of the linked field in the parent table is different for each record, but the value in the linked field in the child table can be the same in multiple records. |
| Orphan | A value in the foreign key that does not have a corresponding primary key in the parent table. |
| Parent table | The main table of a relationship. When creating a relationship, this is the "one" side of the relationship and contains the primary key. |
| Referential Integrity | A property of a relationship between two tables. When Referential Integrity is on, the child table cannot contain a foreign key value that does not have a corresponding value in the primary key of the parent table. |
| Subdatasheet | A child table related to the main (parent) table. |
