foreign key

One or more table fields that refer to the primary key field or fields in another table. A foreign key indicates how the tables are related ¾ the data in the foreign key and primary key fields must match. For example, a list of valid part numbers would contain a foreign key to an inventory table containing references to valid part numbers. Used when establishing referential integrity for a database.