# Can't seem to make Multiple Relation work **URL:** \ **Category:** Ask for Help\ **Created:** [May 4, 2020, 10:09am UTC](https://community.glideapps.com/t/cant-seem-to-make-multiple-relation-work/8435 "2020-05-04T10:09:27Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![maschera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maschera/32/6730_2.png) [@maschera](https://community.glideapps.com/u/maschera)\ **Post date:** [May 4, 2020, 10:09am UTC](https://community.glideapps.com/t/cant-seem-to-make-multiple-relation-work/8435/1 "2020-05-04T10:09:27Z")
Guys, the tool is phenomenal however I got stuck on multiple relations, and it has been for 36h now. My app lists a series of products. Each time that a user clicks on a specific product, I would like them to see recommended items below in a tile format (similar to Amazon’s recommendations). The recommended items are set manually: e.g. if a user clicks on Perfume X, make sure you recommend Aftershave Y and Balm Z. Do you guys have an existing template to share with me to set this type of relations? Thanks a million in advance. ---
**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\ **Post date:** [May 4, 2020, 10:38am UTC](https://community.glideapps.com/t/cant-seem-to-make-multiple-relation-work/8435/2 "2020-05-04T10:38:58Z")
I don’t already have a template, but you could achieve this a couple of ways. The easiest way that comes to mind would be list all your products in one list and assign them all specific “recommend” categories (x, y, and z would have the same category). Then do a multiple relation to the category. —the only issue with this is that the product they’re currently viewing will also be in the list. I wish there was a special value filter condition for “is/is not current row”…could also potentially solve this issue I’m having: [Button \> Link to Screen \> Same List Item?](https://community.glideapps.com/t/button-link-to-screen-same-list-item/8372) ---
**Author:** ![maschera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maschera/32/6730_2.png) [@maschera](https://community.glideapps.com/u/maschera)\ **Post date:** [May 4, 2020, 11:26am UTC](https://community.glideapps.com/t/cant-seem-to-make-multiple-relation-work/8435/3 "2020-05-04T11:26:57Z")
Thanks Robert. I understand the glitch, however if I’m recommending a totally different category, the issue shouldn’t present. E.g. item I’m visiting is in the “Perfumes” category. Related categories are “Aftershaves” and “Balms”, so I don’t think I will be recommended Perfumes again. I will give it a shot right away and let you know. Thanks again. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [May 5, 2020, 2:42am UTC](https://community.glideapps.com/t/cant-seem-to-make-multiple-relation-work/8435/4 "2020-05-05T02:42:44Z")
You could have a list next to this list that has the recommended items and use a filter that identifies that list based on the product in the list next to it. If you cannot get this to work. Let me know. I can take a look at it for you and get it up and running. ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [May 10, 2020, 12:29pm UTC](https://community.glideapps.com/t/cant-seem-to-make-multiple-relation-work/8435/5 "2020-05-10T12:29:31Z")
I built a Movies recommendation app based on Genre. [https://recommendations.glideapp.io](https://recommendations.glideapp.io) It is functional, with a few issues, but to be honest, I don’t like it. I created: - a separate column for each genre - a separate inline list for each genre - a layout to show movies from each genre using the inline list associated with that genre ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/26f21a71b87743e693de0dff5f7dd3dc208d643a.png) - a condition to check if the item in the inline list had the genre in the Genre column (to filter out blanks) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/7/778789f1ef302e5d9114a703e9f5e18d1fcdc7c1.png) I am not a fan of this because it is not scalable. This design requires a separate column for each genre, and there could be any number of columns for each classification (Genre, Cast, etc.) Besides, I would like the recommendations list to be a single list, instead of 7 lists that vary in length currently. A single list would allow me to limit the items to a few only. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/0/012317ee18ac3914510ee07aa516a28a5ce2fa5f.jpeg) Anybody has any better ideas that are better than this brute force approach? ---
**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:** [May 10, 2020, 12:38pm UTC](https://community.glideapps.com/t/cant-seem-to-make-multiple-relation-work/8435/6 "2020-05-10T12:38:12Z")
How are you choosing your “recommendations list”, is there a column for that? ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [May 10, 2020, 12:50pm UTC](https://community.glideapps.com/t/cant-seem-to-make-multiple-relation-work/8435/7 "2020-05-10T12:50:42Z")
It is not a single list. There are 7 lists for each genre. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [May 10, 2020, 2:31pm UTC](https://community.glideapps.com/t/cant-seem-to-make-multiple-relation-work/8435/8 "2020-05-10T14:31:31Z")
Why not use the buttons across bottom of app for each genre so you r menus are more customizeable and appealing? ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [May 10, 2020, 3:22pm UTC](https://community.glideapps.com/t/cant-seem-to-make-multiple-relation-work/8435/9 "2020-05-10T15:22:23Z")
That’s not the point of this conversation. 🙂 ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [May 10, 2020, 4:01pm UTC](https://community.glideapps.com/t/cant-seem-to-make-multiple-relation-work/8435/10 "2020-05-10T16:01:55Z")
I was responding to the genre for movies. I already gave a solution for this post:) I saw someone (you) state they were unhappy with theirapp, if you use the bottom buttons to create the first subgenre you could use the drop down for the second then my method for the 3rd and 4th. It would look a lot more professional. ---
**Author:** ![Drearystate](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/drearystate/32/49605_2.png) [@Drearystate](https://community.glideapps.com/u/Drearystate)\ **Post date:** [May 10, 2020, 4:04pm UTC](https://community.glideapps.com/t/cant-seem-to-make-multiple-relation-work/8435/11 "2020-05-10T16:04:55Z")
Also use a list that when a item is selected it is temporarliy saved in your google sheet that uses that data as a vlookup to identify another list. All simple things my friend 🙂 ---
**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:** [May 10, 2020, 6:08pm UTC](https://community.glideapps.com/t/cant-seem-to-make-multiple-relation-work/8435/12 "2020-05-10T18:08:09Z")
You should only need to create 5 or so columns in the movies sheet. Name then ‘Genre 1’, Genre 2’, etc. This will create an array column of ‘Genre’ that you will use to create a relation back to the same ‘Genre’ column in the same sheet. This will give you a list of all movies that have matching genres. If you need more than 5 genres for a single movie, then simply create more. Completely scaleable and you only need one inline list. ---
**Author:** ![sardamit](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sardamit/32/263_2.png) [@sardamit](https://community.glideapps.com/u/sardamit)\ **Post date:** [May 10, 2020, 7:51pm UTC](https://community.glideapps.com/t/cant-seem-to-make-multiple-relation-work/8435/13 "2020-05-10T19:51:00Z")
@Jeff_Hager - I was working late last night when I did exactly what you have suggested. Perhaps I was too exhausted/occupied to see that it worked. I rebuilt the app and it works like a charm. Looks like I raised a false alarm! 🙂 Thank you, @Jeff_Hager. You’re awesome, as always.