Once you have identified the common fields, you can establish relationships between tables. To create a relationship, simply drag the common field from one table to another in Diagram View.