How to create relationship between two tables

Which key defines relationship between two tables?

A primary keyforeign key relationship defines a one-to-many relationship between two tables in a relational database.

How can you edit a relationship already established between two tables?

  1. Click on the Database Tools tab, and then click on the Relationships tool in the Show/Hide group on the ribbon.
  2. Double-click the line joining the two tables whose relationship you want to modify.
  3. Make the required changes.
  4. Click OK.

How do you create a relationship between two tables in Excel?

Give each table a meaningful name: In Table Tools, click Design > Table Name > enter a name. Verify the column in one of the tables has unique data values with no duplicates. Excel can only create the relationship if one column contains unique values.