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, the TitleAuthor table in the Pubs sample database contains the foreign key Au_ID, which refers to the Au_ID primary key of the Authors table.