Question: what is the relationship between two tables?
Answer: Kinds of table relationships. A relationship works by matching data in key columns, usually columns (or fields) that have the same name in both tables. In most cases, the relationship connects the primary key, or the unique identifier column for each row, from one table to a field in another table.