Create a table relationship by using the Relationships window On the Database Tools tab, in the Relationships group, click Relationships. If you have not yet defined any relationships, the Show Table dialog box automatically appears. Select one or more tables or queries and then click Add. Click to see full answer. Also, how do you create a relationship between two tables in Excel? To create a relationship between the two tables do the following: Click the Data tab. Click Relationships in the Data Tools group. From the first Table dropdown, choose DailyTotalsTable. In the Column (Foreign) dropdown, choose City. In the Related Table dropdown, choose SitesTable. Beside above, which key defines a relationship between two tables? A relationship works by matching data in key columns, usually columns (or fields) that have the same name in both tables. In most cases, the relationship connects the primary key, or the unique identifier column for each row, from one table to a field in another table. Similarly one may ask, what is the use of creating relationship between tables? A relationship between tables is an important aspect of a good relational database. 1) It establishes a connection between a pair of tables that are logically related to each other. 2) It helps to refine table structures and minimize redundant data.Can you create relationships in Excel?When you import related tables from a relational database, Excel can often create those relationships in the Data Model it’s building behind the scenes. 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.