For example, in a customer order table, the salesperson field might contain an employee number. That field would be a foreign key in the table, because the employee table would be indexed on ...

A foreign key is a relationship between two entities ... These common columns would be used in a join between these tables within a query. From our above example, an ORDER LINE table would likely have ...