# Create Hierarchy Levels : GlideNoob **URL:** \ **Category:** Ask for Help\ **Created:** [April 25, 2021, 7:09am UTC](https://community.glideapps.com/t/create-hierarchy-levels-glidenoob/26005 "2021-04-25T07:09:11Z")\ **Posts on this page:** 18\ **Page:** 1
**Author:** ![AGR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agr/32/25439_2.png) [@AGR](https://community.glideapps.com/u/AGR)\ **Post date:** [April 25, 2021, 7:09am UTC](https://community.glideapps.com/t/create-hierarchy-levels-glidenoob/26005/1 "2021-04-25T07:09:11Z")
Hi, It might be too easy, but I am a first time user. So please bear with my naivty. I’m creating a pet boarding app & I’ve data of different boardings under different cities in spreadsheet tabs. I am planning to put these cities in a tile fashion on the landing page. After a user clicks the city tile, s/he be able to see the list of boardings and further details one level down. Please help the noob! ---
**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:** [April 25, 2021, 8:02am UTC](https://community.glideapps.com/t/create-hierarchy-levels-glidenoob/26005/2 "2021-04-25T08:02:48Z")
[https://docs.glideapps.com/all/guides/deep-dives/design/subcategories](https://docs.glideapps.com/all/guides/deep-dives/design/subcategories) This might be helpful for you. For the data structure here, I would have a City sheet with all cities, then the Boarding sheet with all boardings related to those cities. Create a relation from the City to the Boarding sheet, using the city info as the link. ---
**Author:** ![AGR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agr/32/25439_2.png) [@AGR](https://community.glideapps.com/u/AGR)\ **Post date:** [April 25, 2021, 11:09am UTC](https://community.glideapps.com/t/create-hierarchy-levels-glidenoob/26005/3 "2021-04-25T11:09:35Z")
![Pet](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/1/c17b96de27a34145416771843a1fbb91d9a168a7.jpeg) Hi ThinhDinh, If you see in the above screenshot. I created a tab “Cities” with all city names and other tabs for multiple cities. Do you think this is the right approach? ---
**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, 2021, 11:38am UTC](https://community.glideapps.com/t/create-hierarchy-levels-glidenoob/26005/4 "2021-04-25T11:38:45Z")
That approach isn’t going to scale very well. Imagine what it will look like when you have hundreds of cities… You probably should try and condense all of those named city sheets into a single sheet. ---
**Author:** ![AGR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agr/32/25439_2.png) [@AGR](https://community.glideapps.com/u/AGR)\ **Post date:** [April 25, 2021, 11:49am UTC](https://community.glideapps.com/t/create-hierarchy-levels-glidenoob/26005/5 "2021-04-25T11:49:52Z")
Tried that as well. But when i go inside the list, data is not appearing. You can see the left pane, relation is established. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/6/f65a16fa0304976b06114169d1c087c1acab724e.png) ---
**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, 2021, 11:52am UTC](https://community.glideapps.com/t/create-hierarchy-levels-glidenoob/26005/6 "2021-04-25T11:52:37Z")
What does you “Pune” table look like? ---
**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, 2021, 11:56am UTC](https://community.glideapps.com/t/create-hierarchy-levels-glidenoob/26005/7 "2021-04-25T11:56:14Z")
> [@AGR](#): > > I’m creating a pet boarding app & I’ve data of different boardings under different cities in spreadsheet tabs. > > I am planning to put these cities in a tile fashion on the landing page. After a user clicks the city tile, s/he be able to see the list of boardings and further details one level down. Can you show a screen shot of one of these Cities sheets please? If we can see the structure, then we can probably offer some better advice. Also, are all of those sheets identical in terms of structure? (ie. do they all have exactly the same columns?) ---
**Author:** ![AGR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agr/32/25439_2.png) [@AGR](https://community.glideapps.com/u/AGR)\ **Post date:** [April 25, 2021, 11:58am UTC](https://community.glideapps.com/t/create-hierarchy-levels-glidenoob/26005/8 "2021-04-25T11:58:15Z")
Hi Darren, As advised, I am trying to use a single sheet for all the cities. For, example, when I am filtering Pune. It looks like this - ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8e978c2415e0d338ff4fa844f5b1ba544a0634d9.png) ---
**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, 2021, 12:03pm UTC](https://community.glideapps.com/t/create-hierarchy-levels-glidenoob/26005/9 "2021-04-25T12:03:47Z")
Okay, that’s better. Now, in Glide you have a table called Cities, that just lists all the city names, right? What you need to do is create a multi-relation in that sheet that links the city name to the city name in your combined sheet. ---
**Author:** ![AGR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agr/32/25439_2.png) [@AGR](https://community.glideapps.com/u/AGR)\ **Post date:** [April 25, 2021, 12:06pm UTC](https://community.glideapps.com/t/create-hierarchy-levels-glidenoob/26005/10 "2021-04-25T12:06:20Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/b/cb8e43a834f2445f1f9dd803962475ebe1ce9e13.png) Exactly. Would be it possible for you to guide me on the multi-relation process? ---
**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, 2021, 12:09pm UTC](https://community.glideapps.com/t/create-hierarchy-levels-glidenoob/26005/11 "2021-04-25T12:09:33Z")
Watch this… it explains it much better than I can 😉 [https://docs.glideapps.com/all/guides/quick-starts/intermediate-techniques/match-multiple-relations](https://docs.glideapps.com/all/guides/quick-starts/intermediate-techniques/match-multiple-relations) ---
**Author:** ![AGR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agr/32/25439_2.png) [@AGR](https://community.glideapps.com/u/AGR)\ **Post date:** [April 25, 2021, 12:11pm UTC](https://community.glideapps.com/t/create-hierarchy-levels-glidenoob/26005/12 "2021-04-25T12:11:41Z")
Haha, watched that before and that’s how I was able to reach the point where i am not able to see anything under “Pune”. The list is empty inside. I am sure, I am doing some blunder 😊 ---
**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, 2021, 12:14pm UTC](https://community.glideapps.com/t/create-hierarchy-levels-glidenoob/26005/13 "2021-04-25T12:14:57Z")
Show me the configuration of your relation column ---
**Author:** ![AGR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agr/32/25439_2.png) [@AGR](https://community.glideapps.com/u/AGR)\ **Post date:** [April 25, 2021, 12:16pm UTC](https://community.glideapps.com/t/create-hierarchy-levels-glidenoob/26005/14 "2021-04-25T12:16:29Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/2/020b37000ceaa108552770243e904016df743384.png) Here you go! ---
**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, 2021, 12:18pm UTC](https://community.glideapps.com/t/create-hierarchy-levels-glidenoob/26005/15 "2021-04-25T12:18:01Z")
um, that looks like it’s creating a relation to itself. You should be joining to the city name in the sheet that has all the details Eg. Boarding → City Then you use that relation column as the source for your inline list ---
**Author:** ![AGR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agr/32/25439_2.png) [@AGR](https://community.glideapps.com/u/AGR)\ **Post date:** [April 25, 2021, 12:26pm UTC](https://community.glideapps.com/t/create-hierarchy-levels-glidenoob/26005/16 "2021-04-25T12:26:44Z")
Darren, Apologies for bothering you too much. If you see in the left pane, Mumbai is mapped to multiple line items from the Boarding sheet but screen is still empty. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/6/f65ce1a17215e98be55a3712c8b6fbfb5c13f496.png) ---
**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, 2021, 12:50pm UTC](https://community.glideapps.com/t/create-hierarchy-levels-glidenoob/26005/17 "2021-04-25T12:50:32Z")
Sorry, I gave you a bum steer… - For the first screen, add an inline list and use your Cities table as the source - Tapping on a City will bring you to that screen above (View Details) - Add a second inline list to that screen, using the relation column as the source ---
**Author:** ![AGR](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agr/32/25439_2.png) [@AGR](https://community.glideapps.com/u/AGR)\ **Post date:** [April 25, 2021, 2:04pm UTC](https://community.glideapps.com/t/create-hierarchy-levels-glidenoob/26005/18 "2021-04-25T14:04:14Z")
Thanks a lot Darren! This community is amazing.