Question

How primary key is useful to create relation between tables?

Answer 1

A table relationship works by matching data in key fields often a field with the same name in bothtables. In most cases, these matching fields are the primary key from one table, which provides a unique identifier for each record, and a foreign key in the othertable.