You relate tables to one another by using fields.

You relate tables to one another by using Matching fields

Explanation:

If there are more than one table in the database, then mostly there would be a relationship existing between the two table.

For Eg. There would be Department table where this table contains details of department number, department name and Name of the primary incharge, etc. There would be a table called “Employee” where it would contain the name of the employee along with his personal information and there would be a column where each employee would be associated with the department and would contain a field called as “department number”.

So here the database contains more than one table and these two are related using department number which is common to both the table.