What is a foreign key?

A foreign key is a constraint that establishes a relationship between two tables. This relationship typically involves the primary key field(s) from one table with an adjoining set of field(s) in another table (may be the same table). The adjoining field(s) is the foreign key.