How to create relationship between two tables
Which key defines relationship between two tables?
A primary key–foreign 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?
Explanation:
- Click on the Database Tools tab, and then click on the Relationships tool in the Show/Hide group on the ribbon.
- Double-click the line joining the two tables whose relationship you want to modify.
- Make the required changes.
- 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.