A FOREIGN KEY is a field (or collection of fields) in one table, that refers to the PRIMARY KEY in another table.

A field (or group of fields) in one table that points to the primary key in another table is known as a FOREIGN KEY. The table that has the main key is referred to as the referenced or parent table, while the table that has the foreign key is called the child table.