In the Create Relationship dialog box ... The Foreign key helps to connect multiple tables in a database or Excel spreadsheet. The Foreign key is to be a column that is in both tables.

In relational database theory, they’re called primary ... Sometimes you have to create a relationship manually. When all else fails, you might have to create the relationship yourself.