# How to select hierarchical item **URL:** \ **Category:** Ask for Help\ **Created:** [July 21, 2021, 12:26am UTC](https://community.glideapps.com/t/how-to-select-hierarchical-item/29364 "2021-07-21T00:26:44Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Peter\_Sloan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/peter_sloan/32/29254_2.png) [@Peter\_Sloan](https://community.glideapps.com/u/Peter_Sloan)\ **Post date:** [July 21, 2021, 12:26am UTC](https://community.glideapps.com/t/how-to-select-hierarchical-item/29364/1 "2021-07-21T00:26:44Z")
I have a list of clients that are grouped hierarchically e.g Auckland ,.,.Devonport ,.,.,.,.James Smith \* ,.,.,.,…Paul Timms \* Wellington ,.,.Upper Hutt ,.,.,.,.Brian Green \* where the '\*" are the clients and the rest are the groups At the moment I can add groups and clients with multiple levels. My question is how do I bring up a form to select a client on another form? ---
**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:** [July 21, 2021, 12:43am UTC](https://community.glideapps.com/t/how-to-select-hierarchical-item/29364/2 "2021-07-21T00:43:27Z")
Do you mean you want to select clients from a choice component? Also just to confirm, you already have separate tables to store groups and clients, is that correct? ---
**Author:** ![Peter\_Sloan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/peter_sloan/32/29254_2.png) [@Peter\_Sloan](https://community.glideapps.com/u/Peter_Sloan)\ **Post date:** [July 21, 2021, 1:03am UTC](https://community.glideapps.com/t/how-to-select-hierarchical-item/29364/3 "2021-07-21T01:03:57Z")
If I could use a choice component to select a client that would be good but it would obviously need to be able to navigate up and down the levels before selecting the client. I have it on the same table at the moment. Ideally it should be two separate tables as that makes more sense but I couldn’t work out when doing an add to make it add to the client table or the group table ---
**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:** [July 21, 2021, 2:20am UTC](https://community.glideapps.com/t/how-to-select-hierarchical-item/29364/4 "2021-07-21T02:20:21Z")
So you mean you should be able to select the location first, then in the second choice component you’ll be able to choose from the people that belong to that location? Please restructure your data to multiple tables like below. **Locations** : Location name/Plus whatever columns you need here. **Clients** : Client name/Location name. Then after you select the location, in the clients choice you can filter by location name is screen’s location choice. ---
**Author:** ![Peter\_Sloan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/peter_sloan/32/29254_2.png) [@Peter\_Sloan](https://community.glideapps.com/u/Peter_Sloan)\ **Post date:** [July 21, 2021, 10:05pm UTC](https://community.glideapps.com/t/how-to-select-hierarchical-item/29364/5 "2021-07-21T22:05:54Z")
Thanks for the replies. I’ll change my tables to be location and client. My next question is how to create a form that allows you to navigate through the unlimited levels to choose a client that comes up when pressing a button on another form ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [July 21, 2021, 10:29pm UTC](https://community.glideapps.com/t/how-to-select-hierarchical-item/29364/6 "2021-07-21T22:29:30Z")
Hola @Peter_Sloan I think my demo APP for multi choices and relations can help you to start (but it doesn’t use forms) > **[Multi Choices](https://dynchoices.glideapp.io/)** > > How create Dynamic Choices using Relations Saludos! ---
**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:** [July 21, 2021, 10:34pm UTC](https://community.glideapps.com/t/how-to-select-hierarchical-item/29364/7 "2021-07-21T22:34:22Z")
May I ask why don’t you do it in one form only? Can you explain more about using multiple forms here? ---
**Author:** ![Peter\_Sloan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/peter_sloan/32/29254_2.png) [@Peter\_Sloan](https://community.glideapps.com/u/Peter_Sloan)\ **Post date:** [July 26, 2021, 4:05am UTC](https://community.glideapps.com/t/how-to-select-hierarchical-item/29364/8 "2021-07-26T04:05:42Z")
Let’s assume that the first screen could be any form that requires the selection of a client. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/3/132904750bdd5e7ec9ffcf9c2bb03d42cebea35c.png) ---
**Author:** ![Peter\_Sloan](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/peter_sloan/32/29254_2.png) [@Peter\_Sloan](https://community.glideapps.com/u/Peter_Sloan)\ **Post date:** [July 26, 2021, 4:07am UTC](https://community.glideapps.com/t/how-to-select-hierarchical-item/29364/9 "2021-07-26T04:07:48Z")
Screens 2,3 and 4 are built up by the data and is dependent on how many levels are created.