> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://help.syncbase.app/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# ✚ How to link tables and display data from a tab to another one?

| Are you an “historic” user and want to get the **linked tables** feature in your existing Airtable-synced base? 💬 Just ping us on the live chat, we’ll enable it for you. 

Good news! Your tables are now **linked together automatically** during onboarding.
Nothing to do on your side. 🙂


# How linked records work

When your Airtable-synced base is created, SyncBase automatically links related tables together during onboarding.
This means that **Linked Record fields are created for you**, and they are **filled in automatically** based on Shopify relationships. You don’t need to create or configure anything manually.

|| ⚠️ Please do not modify, rename, or delete any of these linked fields. SyncBase uses them to navigate between tables and keep your data consistent. Any change will break the sync. You can simply hide them from the view in Airtable. 

### What is a linked record?

A **Linked Record** field creates a connection between two tables that are related to each other.

__For example__:

* A **Product** can have multiple **Variants**
* A **Variant** always belongs to one **Product**

__Because of this relationship__:

* The **Products** table contains a **Variants** linked record field
* The **Variants** table contains a **Product** linked record field

These links reflect Shopify’s data structure and stay in sync automatically.

### Example: Products and Variants

__In the **Products** table, you’ll find a **Variants** field__:

* This field lists all Variant records linked to each Product
* Clicking a Variant opens the corresponding record in the Variants table

__In the **Variants** table, you’ll find a **Product** field__:

* This field links each Variant to its parent Product
* The link is always kept up to date by SyncBase

![](https://storage.crisp.chat/users/helpdesk/website/-/3/5/e/8/35e84c43b53ca800/linked-records_11bql74.png =700x466)
|| You can find the full list of Linked records in this article: [Data synced with SyncBase](https://help.syncbase.app/en/article/data-synced-with-syncbase-1cecyb3/)


# How to display data from one table to another?

You can easily bring more data from one table into another creating your own **Lookup fields**.

__For example, to display the Product Title into the Variants table__:

1. Add a new field in **Variants**.
2. Select **Lookup** as the field type.
3. Source: your `Products` field.
4. Field: choose **Title** from the Products table.
5. Click **Create field**.

✅ Each Variant now shows its Product Title automatically.

![](https://storage.crisp.chat/users/helpdesk/website/-/3/5/e/8/35e84c43b53ca800/lookup-field-video_rl4m79.gif =700x700)