# Multiple Relationships **URL:** \ **Category:** Ask for Help\ **Created:** [April 21, 2021, 4:36pm UTC](https://community.glideapps.com/t/multiple-relationships/25865 "2021-04-21T16:36:04Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Pablo\_Reyna](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablo_reyna/32/49850_2.png) [@Pablo\_Reyna](https://community.glideapps.com/u/Pablo_Reyna)\ **Post date:** [April 21, 2021, 4:36pm UTC](https://community.glideapps.com/t/multiple-relationships/25865/1 "2021-04-21T16:36:05Z")
Hello No Coders, I need help with creating multiple relationships. I’m going crazy. My brain is burning and I think it’s easier than I think, but I can’t get it right. The problem lies in assembling the data sheet with the relationships of categories and sub categories. I have 4 categories on one sheet: ![983086877b428162c9ac1e919be9bca791296ccf](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/c/cc80dcdc655b62a3679826fe0a0f5c9c6cb64a0a.png) And I have on another sheet, 2 sub-categories and a product column that depend (children) on each sub-category: ![subcategorias y productos](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/9/693b477e0256372ab38c13dfbf88f345585b1d64.png) The question is: How do I build relationships? Are they well distributed over two sheets or do I need to add more sheets? I did the flow from left to right, and I need to develop it as follows: Click on [Category], and [Sub-Category 1] opens showing its content, then when clicking [Sub-Category 1], [Sub-Category 2] opens and shows its content, and by Finally, click on [Sub-Category 2] and show me the final product belonging to that tree. I would be very grateful if you could guide me to do it myself and learn. Thank you Best regards ---
**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 21, 2021, 4:42pm UTC](https://community.glideapps.com/t/multiple-relationships/25865/2 "2021-04-21T16:42:15Z")
Personally, I like to do something like this with 3 sheets. One sheet to list the Category, one to list the Subcategory1, and one to list the Subcategory2. You could technically do it with one sheet, but you start to run into some problems because each level is sharing the same details layout. Separating into separate sheets makes it easier to have different layouts for each level, but that’s up to you. I just think it’s more work and more confusing to put multiple levels of data in the same sheet. ---
**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 21, 2021, 4:44pm UTC](https://community.glideapps.com/t/multiple-relationships/25865/3 "2021-04-21T16:44:31Z")
Your second screenshot would still be your final sheet if you split up each level of categories. What I do is create template columns that combine each category level together so you can use them for relations. ---
**Author:** ![Pablo\_Reyna](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablo_reyna/32/49850_2.png) [@Pablo\_Reyna](https://community.glideapps.com/u/Pablo_Reyna)\ **Post date:** [April 21, 2021, 4:46pm UTC](https://community.glideapps.com/t/multiple-relationships/25865/4 "2021-04-21T16:46:36Z")
Hi Jeff! It seemed to me that this could be the correct answer, since I had thought about doing it but could not find a way to build relationships. Now is the task of “how to build the relationships” between the different sheets. Thank you very much for your prompt reply! Best regards ---
**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 21, 2021, 4:48pm UTC](https://community.glideapps.com/t/multiple-relationships/25865/5 "2021-04-21T16:48:45Z")
I did something similar in the Concepts app a long time ago. You can take a look at that to get a better understanding. Just look for the Multi-Level Select example. > **[Concepts](https://concepts.glideapp.io/)** > > Made with Glide from a Google Sheet, without writing any code. ---
**Author:** ![Pablo\_Reyna](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablo_reyna/32/49850_2.png) [@Pablo\_Reyna](https://community.glideapps.com/u/Pablo_Reyna)\ **Post date:** [April 21, 2021, 4:50pm UTC](https://community.glideapps.com/t/multiple-relationships/25865/6 "2021-04-21T16:50:13Z")
Here would be my complication! I would have to figure that out since I don’t know how to do it. I will try and if I can’t make it, I will ask for help again. Thanks again ---
**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 21, 2021, 4:50pm UTC](https://community.glideapps.com/t/multiple-relationships/25865/7 "2021-04-21T16:50:56Z")
You can copy the app to see how it’s set up. ---
**Author:** ![Pablo\_Reyna](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pablo_reyna/32/49850_2.png) [@Pablo\_Reyna](https://community.glideapps.com/u/Pablo_Reyna)\ **Post date:** [April 21, 2021, 4:51pm UTC](https://community.glideapps.com/t/multiple-relationships/25865/8 "2021-04-21T16:51:29Z")
Excellent Jeff! there I check it 👌 ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [April 21, 2021, 4:55pm UTC](https://community.glideapps.com/t/multiple-relationships/25865/9 "2021-04-21T16:55:05Z")
I thought about something similar. > **[Copy of categories](https://entertaining-addition-0241.glideapp.io/)** ---
**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 21, 2021, 5:18pm UTC](https://community.glideapps.com/t/multiple-relationships/25865/10 "2021-04-21T17:18:36Z")
Yep, that’s the advantage of separate sheets. Each level can have a different design to the list, along with any additional content you may want to display on the screen.