# How to make a "2 ways" relation between tables?

**URL:** <https://community.glideapps.com/t/how-to-make-a-2-ways-relation-between-tables/58088>\
**Category:** Ask for Help\
**Created:** [February 17, 2023, 3:17pm UTC](https://community.glideapps.com/t/how-to-make-a-2-ways-relation-between-tables/58088 "2023-02-17T15:17:25Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [February 17, 2023, 3:27pm UTC](https://community.glideapps.com/t/how-to-make-a-2-ways-relation-between-tables/58088/2 "2023-02-17T15:27:34Z")

</div>

- Configure your choice component so that it writes a comma separated list of UserID’s (RowID) into a column in your Teams table (you do this by enabling multi-select)
- Add a Split Text column in your Teams table that targets the column containing the UserID’s
- Now create a multiple relation column in your Teams table that matches the split text column with Users-\>RowID
- And in your Users table, create a multiple relation that matches RowID with the split text column in your Teams table.

Each of the relations can then be used as the source of a list/collection component. For example, on your Teams detail screen you can add a collection and set the source as the relation in your Teams table, and that will give you a list of all users in that Team.

---

_[View the full topic](https://community.glideapps.com/t/how-to-make-a-2-ways-relation-between-tables/58088)._