# How to relate shop name and retrieve **URL:** \ **Category:** Ask for Help\ **Created:** [September 20, 2021, 5:40pm UTC](https://community.glideapps.com/t/how-to-relate-shop-name-and-retrieve/32049 "2021-09-20T17:40:52Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\ **Post date:** [September 20, 2021, 5:40pm UTC](https://community.glideapps.com/t/how-to-relate-shop-name-and-retrieve/32049/1 "2021-09-20T17:40:52Z")
Hi All, How can I relate shop name to retrieve from product list that this shop have these products. ![IMG_20210920_230903](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/1/f1897f5dab1c5104bb5825db014142f5b70c7f65.jpeg) ![IMG_20210920_230842](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/a/4a465e89f3b2bd4de8753349af62116422023023.jpeg) I have the inlinelist showing shop name and image, For each shop it should list corresponding products if I click. ---
**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:** [September 20, 2021, 5:49pm UTC](https://community.glideapps.com/t/how-to-relate-shop-name-and-retrieve/32049/2 "2021-09-20T17:49:32Z")
Create a relation column that links the shop name in the ‘Trending Shops’ sheet to the shop name in the ‘ProductList’ sheet. Then when you click on a shop in an inline list, it will bring you to the details of that shop, where you can add an inline list that uses the relation of products as the source. Just a word of advice for taking screenshots. Use the Windows Snipping Tool. It will save you a lot of time and provide much better screenshots for us to view. [https://support.microsoft.com/en-us/windows/open-snipping-tool-and-take-a-screenshot-a35ac9ff-4a58-24c9-3253-f12bac9f9d44](https://support.microsoft.com/en-us/windows/open-snipping-tool-and-take-a-screenshot-a35ac9ff-4a58-24c9-3253-f12bac9f9d44) ---
**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\ **Post date:** [September 20, 2021, 6:40pm UTC](https://community.glideapps.com/t/how-to-relate-shop-name-and-retrieve/32049/3 "2021-09-20T18:40:18Z")
Sorry,I’m using my phone to take photo to send screenshot. ![IMG_20210921_000526](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/e/6ec64f25d7483525944716f87034fc0a3c3e2aff.jpeg) Its retrieving the product now but it’s showing all the product list. Screenshot attached for Dubai Burqas shop name has only one product in product list but showing all the product in product list. Am I missing something? ![IMG_20210921_000818](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/e/5e98606d2c7201b608fd06199b8d57afbf5bf3b6.jpeg) ![IMG_20210921_000842](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/9/99a772f05693b971585669a03681c957d7439ebc.jpeg) ---
**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:** [September 20, 2021, 6:43pm UTC](https://community.glideapps.com/t/how-to-relate-shop-name-and-retrieve/32049/4 "2021-09-20T18:43:42Z")
> [@Manikandan\_R](#): > > Sorry,I’m using my phone to take photo to send screenshot. You can copy and paste the screenshot into the forum directly in windows without having to use your phone. > [@Manikandan\_R](#): > > Its retrieving the product now but it’s showing all the product list. Is your inline list using the relation or the entire sheet as the source? ---
**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\ **Post date:** [September 20, 2021, 6:47pm UTC](https://community.glideapps.com/t/how-to-relate-shop-name-and-retrieve/32049/5 "2021-09-20T18:47:14Z")
I’m not getting that relation in the source column. ---
**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:** [September 20, 2021, 6:47pm UTC](https://community.glideapps.com/t/how-to-relate-shop-name-and-retrieve/32049/6 "2021-09-20T18:47:39Z")
Change it to use the relation. That was the purpose of creating the relation. ---
**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\ **Post date:** [September 20, 2021, 7:00pm UTC](https://community.glideapps.com/t/how-to-relate-shop-name-and-retrieve/32049/7 "2021-09-20T19:00:41Z")
I’m not getting that relation column in source. ---
**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:** [September 20, 2021, 7:13pm UTC](https://community.glideapps.com/t/how-to-relate-shop-name-and-retrieve/32049/8 "2021-09-20T19:13:27Z")
Based on your screenshots, it looks like you are viewing the details screen of ‘Dubai Burqas’. So you have an inline list component on that screen and you don’t see your ‘shopRelProd’ relation at all? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/b/fb3b39279c7964bfe59ce1996a12ae5c65c8655c.png) ---
**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\ **Post date:** [September 20, 2021, 7:14pm UTC](https://community.glideapps.com/t/how-to-relate-shop-name-and-retrieve/32049/9 "2021-09-20T19:14:55Z")
![IMG_20210921_004210](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/f/fffed38b5f91d88e3a91e21b8fc091a5c26a07a0.jpeg) Why I’m getting this.offers sheet doesn’t have a relation column. I’m relating only shops and it’s products.its also retrieving it but the relation column is not comes under the source column in the inline list trending shops. ---
**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:** [September 20, 2021, 7:16pm UTC](https://community.glideapps.com/t/how-to-relate-shop-name-and-retrieve/32049/10 "2021-09-20T19:16:54Z")
You should be in the details view of one of your shops. I’ve guessing you are still on the tab level. Your screenshot shows that you are not viewing one of the details of one of your shops. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/d/cd5a677a101f68c53ca87ba63261b2363f25a45a.jpeg) ---
**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\ **Post date:** [September 20, 2021, 7:25pm UTC](https://community.glideapps.com/t/how-to-relate-shop-name-and-retrieve/32049/11 "2021-09-20T19:25:24Z")
I made a mistake of giving new screen in action to show trending shops sheets in source.thats y this happens.finally done it.thanks for helping me to get this. ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:50pm UTC](https://community.glideapps.com/t/how-to-relate-shop-name-and-retrieve/32049/12 "2024-01-17T16:50:28Z")