# Single Item multiple times in an Inline List through Relations

**URL:** <https://community.glideapps.com/t/single-item-multiple-times-in-an-inline-list-through-relations/60788>\
**Category:** Ask for Help\
**Created:** [April 21, 2023, 12:36am UTC](https://community.glideapps.com/t/single-item-multiple-times-in-an-inline-list-through-relations/60788 "2023-04-21T00:36:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![David-Pinkerton](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david-pinkerton/32/57636_2.png) [@David-Pinkerton](https://community.glideapps.com/u/David-Pinkerton)\
**Post date:** [April 21, 2023, 12:36am UTC](https://community.glideapps.com/t/single-item-multiple-times-in-an-inline-list-through-relations/60788/1 "2023-04-21T00:36:06Z")

</div>

I have 3 sheets: Quote, Groups, and Items.

There are multiple Groups in a Quote and the same group can show up in different Quotes, and 1 item can show up in multiple Groups or multiple times in the same group.

So let’s say I have an Item named: “Camera”. This Item Shows up in Group 1 and Group 2 and these two groups are in Quote 1.

Now let’s say I want a single inline list of all items associated with Quote 1 (through Group 1 and Group 2). Since both Group 1 & Group 2 have the item named “Camera” then this list should show the “Camera” item twice.

How do I accomplish this?

---

<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:** [April 21, 2023, 2:18am UTC](https://community.glideapps.com/t/single-item-multiple-times-in-an-inline-list-through-relations/60788/2 "2023-04-21T02:18:26Z")

</div>

Assuming that you have a multiple relation from Quotes to Groups, and then another multiple relation from Groups to Items, then you could do the following:

- In your Groups table, create a Joined List column that targets the Item Name through the multiple relation to Items
- In your Quotes table, create a Joined List column that targets the above column through the multiple relation to Groups
- This should give you a list of all Items associated with each Quote.
- To transform that list into something that could be used as the source of an Inline List, you can use the [Miracle Method](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766)

---

<div class="post-metadata">

**Author:** ![David-Pinkerton](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david-pinkerton/32/57636_2.png) [@David-Pinkerton](https://community.glideapps.com/u/David-Pinkerton)\
**Post date:** [April 24, 2023, 9:48pm UTC](https://community.glideapps.com/t/single-item-multiple-times-in-an-inline-list-through-relations/60788/3 "2023-04-24T21:48:29Z")

</div>

Thank you @Darren_Murphy for your reply. Unfortunately the Miracle Method does not work in this case, because the kinds and number of items are not predetermined.

---

<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:** [April 25, 2023, 1:20am UTC](https://community.glideapps.com/t/single-item-multiple-times-in-an-inline-list-through-relations/60788/4 "2023-04-25T01:20:51Z")

</div>

It will work, all you need to do is make sure you have enough rows in your helper table to cover the maximum possible number of items.