> ## Documentation Index
> Fetch the complete documentation index at: https://docs.anlytic.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Relationships

Relationships are a way to link data from different tables for analysis. A relationship shows how two tables are connected by common fields, but it doesn't merge them into one. When tables are linked by a relationship, they stay separate and keep their own details and information.

<img src="https://mintcdn.com/anlytic/lFS0cPtuwNl4WP3t/Resources/FormRelationships.png?fit=max&auto=format&n=lFS0cPtuwNl4WP3t&q=85&s=ee0f082ce59a59c155b41feda6a1281c" alt="![data relationships in Anlytic]" width="1551" height="912" data-path="Resources/FormRelationships.png" />

## Learning objectives

1. Understand relationships
2. Create data relationships
3. Edit data relationships

## What is the benefit of creating relationships between data?

To understand the benefits of creating relationships, let's take a look at an example. When you use a filter to filter any data, underneath the filters there are data columns connected.

Now, imagine you have two data tables called 'employee' and 'country'. The employee table has a column 'country\_id' that contains the same values as the country table’s column called 'id'. The country table also has a column called 'name'.

Now, if you want to filter the employees by country, how do you do it? You create a filter and then create a field. There you select country name. Now you connect the field to the column called country.name.

If you are doing a query where you need to filter the employee on country. You know you have a filter field set to country name but how do you know that the employees table is connected to country. That is why you need to create a relationship, that shows you the connection between the data.

In next page we are going to walk you through, how you can create data relationships in Anlytic platform.
