# How to Relate items on same column on spreadsheet?

**URL:** https://community.glideapps.com/t/how-to-relate-items-on-same-column-on-spreadsheet/34208
**Category:** Ask for Help
**Created:** [November 8, 2021, 4:08pm UTC](https://community.glideapps.com/t/how-to-relate-items-on-same-column-on-spreadsheet/34208 "2021-11-08T16:08:11Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![Pauly\_Ramirez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pauly_ramirez/32/34162_2.png) [@Pauly\_Ramirez](https://community.glideapps.com/u/Pauly_Ramirez)
#### Post date: [November 8, 2021, 4:08pm UTC](https://community.glideapps.com/t/how-to-relate-items-on-same-column-on-spreadsheet/34208/1 "2021-11-08T16:08:11Z")

</div>

Currently, I am setting up my database, I am making a cost per ingredient on a recipe on glide but I am having an issue with having the recipe title. Is there a way to relate it all to the same column? I tried relations on glide but it didn’t work. Screenshot of the image below.

|

 ![Screen Shot 2021-11-08 at 10.04.47 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/8/78b12d4d035bdc6e6166ba20394456ec32c0f04e.png)

---

<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: [November 8, 2021, 11:51pm UTC](https://community.glideapps.com/t/how-to-relate-items-on-same-column-on-spreadsheet/34208/2 "2021-11-08T23:51:33Z")

</div>

It looks like you have the right data setup here. What do you mean by “relating items” on the same column?

I think you can have a table like this for all ingredients, and in another sheet you have the unique recipes, then you use a relation from that recipes table to the ingredients sheet?

---

<div class="post-metadata">

### Author: ![Pauly\_Ramirez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pauly_ramirez/32/34162_2.png) [@Pauly\_Ramirez](https://community.glideapps.com/u/Pauly_Ramirez)
#### Post date: [November 9, 2021, 12:25am UTC](https://community.glideapps.com/t/how-to-relate-items-on-same-column-on-spreadsheet/34208/3 "2021-11-09T00:25:38Z")

</div>

Forgot to mention another portion. Users will be entering their own recipes and ingredients. What i mean is that I want that in the title show only

Overnight Oats, and then show the ingredients together. Right now its treating each line as a separate recipe instead of one recipe.

 ![Screen Shot 2021-11-08 at 6.24.22 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/1/517df250055475efd79c1ead6e5c38c86b14c7e5.png)

---

<div class="post-metadata">

### Author: ![Pauly\_Ramirez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pauly_ramirez/32/34162_2.png) [@Pauly\_Ramirez](https://community.glideapps.com/u/Pauly_Ramirez)
#### Post date: [November 9, 2021, 12:28am UTC](https://community.glideapps.com/t/how-to-relate-items-on-same-column-on-spreadsheet/34208/4 "2021-11-09T00:28:31Z")

</div>

With your solution of having two sheets one with ingredients and one with unique recipes. How would I go about setting it up so users would be able to add it on their own and have separate recipes?