# How to link several table together

**URL:** <https://community.glideapps.com/t/how-to-link-several-table-together/38419>\
**Category:** Ask for Help\
**Created:** [February 12, 2022, 4:02pm UTC](https://community.glideapps.com/t/how-to-link-several-table-together/38419 "2022-02-12T16:02:50Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ninja](https://avatars.discourse-cdn.com/v4/letter/n/53a042/32.png) [@Ninja](https://community.glideapps.com/u/Ninja)\
**Post date:** [February 12, 2022, 4:02pm UTC](https://community.glideapps.com/t/how-to-link-several-table-together/38419/1 "2022-02-12T16:02:50Z")

</div>

Hello,

I would like to link tables as such:

- A user can have many selections
- A selection can have a personalization (title x text)
- A selection can have many articles

So all information can be added to each table. When I create a relation some of the data do not get duplicated as I have no match. I don’t how to do that.

Can someone help me, please?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 13, 2022, 1:00am UTC](https://community.glideapps.com/t/how-to-link-several-table-together/38419/2 "2022-02-13T01:00:10Z")

</div>

Can you show us how you’re structuring your tables, especially your relations in some screenshots?

You should be able to have 3 tables:

- Users table: with a column to house your choice. Your choice should be powered by a choice component, with multiple choices enabled. You should write selections’ IDs for this, not their actual names.

- Selections table: title, text, relation to Articles table.

- Articles table: Selection ID, plus any other info you need for an article.

---

<div class="post-metadata">

**Author:** ![Ninja](https://avatars.discourse-cdn.com/v4/letter/n/53a042/32.png) [@Ninja](https://community.glideapps.com/u/Ninja)\
**Post date:** [February 13, 2022, 2:10pm UTC](https://community.glideapps.com/t/how-to-link-several-table-together/38419/3 "2022-02-13T14:10:56Z")

</div>

thank @ThinhDinh,

that’s absolutely not what I have done 😂

here are my screenshots:  
**Users table** 🔽  
_Expected goals :_

- Get all users info (Name, email, type (User or Admin)
- They can create a selection and personalize it by adding a title and add an intro, The selection and personalization must be editable

**Theme table** 🔽  
_Expected goal :_

- All articles have a theme

**Articles table** 🔽  
_Expected goal:_

- Can be added or removed from a selection  
 ![Capture d’écran 2022-02-13 à 14.48.44](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/f/2ff6198a9d60d5b1834c5afacf16ac53afa1e70e.png)

**Personalisation table** 🔽  
_Expected goal:_

- For all selections, the user must be able to add a title and a small introduction

**Selection table** 🔽  
_Expected goals:_

- Gather all articles selected by the users
- Must be editable. i.e. the user can add or remove an article from it
- The user can send the selection with the personalization (title x text) via email or an alert can be sent on Slack (I don’t know yet 😅)

I’m going to start again with your instruction. Hope the screenshot will help to understand what I’m aiming for.

PS I cannot add several screenshots. let me know if you want me to send it privately.

Thanks by advance