Relationship

A relationship works by matching data in key columns, usually columns with the same name in both tables. It matches the primary key from one table, which provides a unique identifier for each row, with an entry in the foreign key in the other table.