# How to create a column relation from 1 item to Multiple items on another column?

**URL:** https://community.glideapps.com/t/how-to-create-a-column-relation-from-1-item-to-multiple-items-on-another-column/7457
**Category:** Ask for Help
**Created:** [April 20, 2020, 8:18pm UTC](https://community.glideapps.com/t/how-to-create-a-column-relation-from-1-item-to-multiple-items-on-another-column/7457 "2020-04-20T20:18:58Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![zDesignTeam](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zdesignteam/32/5906_2.png) [@zDesignTeam](https://community.glideapps.com/u/zDesignTeam)
#### Post date: [April 20, 2020, 8:18pm UTC](https://community.glideapps.com/t/how-to-create-a-column-relation-from-1-item-to-multiple-items-on-another-column/7457/1 "2020-04-20T20:18:58Z")

</div>

Hi! I’m new to Glide apps and need help to create this:

1. I’ve a list of Books and a list of Categories.

2. A Book can have Multiple Categories (PS: the amount of categories must be unlimited, because more will be added in the future).

3. Then, the Glide App must allow the user to “view” the Book details screen and list all it’s Categories.

Is there a way to do that?

Thanks in advance!

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 20, 2020, 10:29pm UTC](https://community.glideapps.com/t/how-to-create-a-column-relation-from-1-item-to-multiple-items-on-another-column/7457/2 "2020-04-20T22:29:56Z")

</div>

For this you will need 2 sheets. One that lists all of the books and it’s details. The other sheet will need to list the book in one column and a second column for category. Each book’s category will be listed in separate rows. From the Books sheet, create a relation column to link the book in the books sheet to the book in the categories sheet. You can use the relation to add an inline list of categories in the books details.

---

<div class="post-metadata">

### Author: ![zDesignTeam](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/zdesignteam/32/5906_2.png) [@zDesignTeam](https://community.glideapps.com/u/zDesignTeam)
#### Post date: [April 20, 2020, 11:00pm UTC](https://community.glideapps.com/t/how-to-create-a-column-relation-from-1-item-to-multiple-items-on-another-column/7457/3 "2020-04-20T23:00:45Z")

</div>

Thanks for the reply! I’m going to try that!

---

<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: [May 19, 2024, 4:10am UTC](https://community.glideapps.com/t/how-to-create-a-column-relation-from-1-item-to-multiple-items-on-another-column/7457/4 "2024-05-19T04:10:35Z")

</div>