a column in one table holds the primary key of a row in another table. This is how you link customers to orders, orders to products, and products to categories.