# Populate one choice list based on another choice selection **URL:** \ **Category:** Ask for Help\ **Created:** [July 15, 2020, 7:09pm UTC](https://community.glideapps.com/t/populate-one-choice-list-based-on-another-choice-selection/12549 "2020-07-15T19:09:14Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Navjeet\_Chabbewal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/navjeet_chabbewal/32/10663_2.png) [@Navjeet\_Chabbewal](https://community.glideapps.com/u/Navjeet_Chabbewal)\ **Post date:** [July 15, 2020, 7:09pm UTC](https://community.glideapps.com/t/populate-one-choice-list-based-on-another-choice-selection/12549/1 "2020-07-15T19:09:14Z")
I have 3 sheets. Vehicle, VehicleMake and VehicleModel. VehicleMake has two columns Name and MakeModels which is a has many relation to VehicleModel. In VehicleMake I have 3 columns, Name, Model and ModelMake which is has a relation to VehicleModel sheet. After populating data in Name and Make columns in VehicleModel sheet, I see the relation columns properly populated. Now Vehicle has Make, Model and some other columns like year, color. On the screen to create a Vehicle, I have choice component for Make, Model, Color and Year. After the user selects a Make, I want to show only the models for that selected make in Make choice component but it is nor working. For Model Choice component I have mapped the source to VehicleModel sheet and Name column and in filters I am saying Make is Screen-\>Make but that is not working. Am I applying the filter in a wrong way or is it not doable? ---
**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:** [July 15, 2020, 7:14pm UTC](https://community.glideapps.com/t/populate-one-choice-list-based-on-another-choice-selection/12549/2 "2020-07-15T19:14:32Z")
See if this helps: > [@new Screen Visibility and Filtering Conditions!](https://community.glideapps.com/t/screen-visibility-and-filtering-conditions/12306/4): > > Here’s a demo: Available in my experiments app: [https://experiments.glideapp.io](https://experiments.glideapp.io) ---
**Author:** ![Navjeet\_Chabbewal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/navjeet_chabbewal/32/10663_2.png) [@Navjeet\_Chabbewal](https://community.glideapps.com/u/Navjeet_Chabbewal)\ **Post date:** [July 15, 2020, 8:32pm UTC](https://community.glideapps.com/t/populate-one-choice-list-based-on-another-choice-selection/12549/3 "2020-07-15T20:32:57Z")
This did not help. Seems like there are so many columns in FruitList that things are not very clear. Looks like key columns and ColorChoice and FruitChoice. ColorChoice column is populated on select in color choice. So I added a MakeChoice column but it does not get listed on Column under Data so that I can populate it. ---
**Author:** ![Navjeet\_Chabbewal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/navjeet_chabbewal/32/10663_2.png) [@Navjeet\_Chabbewal](https://community.glideapps.com/u/Navjeet_Chabbewal)\ **Post date:** [July 15, 2020, 9:09pm UTC](https://community.glideapps.com/t/populate-one-choice-list-based-on-another-choice-selection/12549/4 "2020-07-15T21:09:21Z")
I think the issue in my case is that I am on ADD page created by Glide rather than your example is a details page. ---
**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 15, 2020, 10:21pm UTC](https://community.glideapps.com/t/populate-one-choice-list-based-on-another-choice-selection/12549/5 "2020-07-15T22:21:42Z")
@Navjeet_Chabbewal Take a look at [https://dynchoices.glideapp.io](https://dynchoices.glideapp.io) to help you Saludos ---
**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:** [July 16, 2020, 3:08am UTC](https://community.glideapps.com/t/populate-one-choice-list-based-on-another-choice-selection/12549/6 "2020-07-16T03:08:23Z")
Ah…yes. As was referenced later in that thread, this logic doesn’t yet work in Add, Edit or Form screens ---
**Author:** ![Navjeet\_Chabbewal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/navjeet_chabbewal/32/10663_2.png) [@Navjeet\_Chabbewal](https://community.glideapps.com/u/Navjeet_Chabbewal)\ **Post date:** [July 16, 2020, 7:30pm UTC](https://community.glideapps.com/t/populate-one-choice-list-based-on-another-choice-selection/12549/7 "2020-07-16T19:30:07Z")
Then I how do create a details screen from my starting point which is the list of Vehicles. ---
**Author:** ![Navjeet\_Chabbewal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/navjeet_chabbewal/32/10663_2.png) [@Navjeet\_Chabbewal](https://community.glideapps.com/u/Navjeet_Chabbewal)\ **Post date:** [July 16, 2020, 10:01pm UTC](https://community.glideapps.com/t/populate-one-choice-list-based-on-another-choice-selection/12549/8 "2020-07-16T22:01:48Z")
@gvalero I think the issue is that I am on ADD screen not a details screen. See my response above. ---
**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 17, 2020, 12:16am UTC](https://community.glideapps.com/t/populate-one-choice-list-based-on-another-choice-selection/12549/9 "2020-07-17T00:16:35Z")
Ah ok! I didn´t see that important detail As Robert wrote, the relations don’t work in Add, Edit or Form screens. Your plan B could be to make relations outside of these screens (like my DynChoices demo APP makes) and later use a button working as Form to write the selected values to your GS columns automatically if it is what you want to get. Saludos @Navjeet_Chabbewal ---
**Author:** ![Navjeet\_Chabbewal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/navjeet_chabbewal/32/10663_2.png) [@Navjeet\_Chabbewal](https://community.glideapps.com/u/Navjeet_Chabbewal)\ **Post date:** [July 17, 2020, 3:43pm UTC](https://community.glideapps.com/t/populate-one-choice-list-based-on-another-choice-selection/12549/10 "2020-07-17T15:43:56Z")
May be it’s because I am a newbie at Glide, I am not sure how to proceed to create a new vehicle where I can filter car models based on car make selected by the user. @gvalero, @Robert_Petitto, can any of you mind taking a look at my app or I can share the Google sheet and you can show me a basic example? ---
**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 17, 2020, 7:50pm UTC](https://community.glideapps.com/t/populate-one-choice-list-based-on-another-choice-selection/12549/11 "2020-07-17T19:50:52Z")
Sure @Navjeet_Chabbewal Send me a PM with your sheet to take a look at. I think you are close to get what you wish. Feliz día ---
**Author:** ![Navjeet\_Chabbewal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/navjeet_chabbewal/32/10663_2.png) [@Navjeet\_Chabbewal](https://community.glideapps.com/u/Navjeet_Chabbewal)\ **Post date:** [July 17, 2020, 8:34pm UTC](https://community.glideapps.com/t/populate-one-choice-list-based-on-another-choice-selection/12549/12 "2020-07-17T20:34:14Z")
Just sent u the link, let me know if u can copy/open it. ---
**Author:** ![Navjeet\_Chabbewal](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/navjeet_chabbewal/32/10663_2.png) [@Navjeet\_Chabbewal](https://community.glideapps.com/u/Navjeet_Chabbewal)\ **Post date:** [July 18, 2020, 3:15am UTC](https://community.glideapps.com/t/populate-one-choice-list-based-on-another-choice-selection/12549/13 "2020-07-18T03:15:04Z")
I figured it out and the solution was simple. @Robert_Petitto when I looked at your app’s voting tab, that gave me an idea. All I had to do was to include both Model and Make in VehicleModel sheet and filter model names to list values where make is same as make value selected in Make choice component. ---
**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:** [July 18, 2020, 3:16am UTC](https://community.glideapps.com/t/populate-one-choice-list-based-on-another-choice-selection/12549/14 "2020-07-18T03:16:39Z")
Yes! That’s it. I assumed you had both in the same sheet already. My apologies.