# Dynamic Selection

**URL:** <https://community.glideapps.com/t/dynamic-selection/55980>\
**Category:** Ask for Help\
**Created:** [December 22, 2022, 3:40pm UTC](https://community.glideapps.com/t/dynamic-selection/55980 "2022-12-22T15:40:30Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Richard\_Hayden](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/richard_hayden/32/38039_2.png) [@Richard\_Hayden](https://community.glideapps.com/u/Richard_Hayden)\
**Post date:** [December 22, 2022, 3:40pm UTC](https://community.glideapps.com/t/dynamic-selection/55980/1 "2022-12-22T15:40:30Z")

</div>

Hi All. As a new user I have a question which I hope you can help with. I have 350 sporting fixtures taking place at 25 different venues. There is a different team at each venue and there is a defined list of people that can work at each venue. The bit that I am stuck on is - how do I set it up within my database & mobile app so that if the user clicks on Venue 1 - he is presented with a list to choose from applicable to that venue only? At moment using the choice component I can only link it to the full list of people within my database. thanks

---

<div class="post-metadata">

**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:** [December 22, 2022, 4:02pm UTC](https://community.glideapps.com/t/dynamic-selection/55980/2 "2022-12-22T16:02:18Z")

</div>

If you create a relation linking the venue in the venue table to the venue in the people table, then you can use that relation as the source of your choice component.