A FOREIGN KEY is a field (or group of fields) in one table that relates to the PRIMARY KEY in another. The table containing the foreign key is referred to as the child table, whereas the table containing the main key is referred to as the referenced or parent table.