An association between two tables in which the primary key value of each record in the primary table corresponds to the value in the matching field or fields of many records in the related table.