# How to select values from other drop down

**URL:** <https://community.glideapps.com/t/how-to-select-values-from-other-drop-down/54607>\
**Category:** Ask for Help\
**Created:** [November 21, 2022, 7:56am UTC](https://community.glideapps.com/t/how-to-select-values-from-other-drop-down/54607 "2022-11-21T07:56:13Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [November 21, 2022, 7:56am UTC](https://community.glideapps.com/t/how-to-select-values-from-other-drop-down/54607/1 "2022-11-21T07:56:13Z")

</div>

Hi

I have a main category table as a drop down and sub category which is also a drop down showing all the values from sub category table but i need to list only values based on the category selection.  
If i select born baby,it has 2 sub category,it should display 2 values in drop down.

 ![667](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/d/1dd587fd0c0c9252ddccaa04e597c86be44343c0.png)  
 ![668](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/b/9b2412604989cc32010bfd5d71068e60623cfdec.png)  
 ![669](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/4/a4a795c54ae67e64f957586a257008786b846a0b.png)  
 ![770.PNG](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/a/aab2ca8b8accee7f910b829834b1f7d0375d7175.jpeg)

---

<div class="post-metadata">

**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:** [November 21, 2022, 8:27am UTC](https://community.glideapps.com/t/how-to-select-values-from-other-drop-down/54607/2 "2022-11-21T08:27:59Z")

</div>

Filter your Sub-Category selector using Screen Values

> **[Glide Docs • Screen Values](https://www.glideapps.com/docs/reference/values/screen-values)**
>
> Values that you can access from the current screen.

---

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [November 21, 2022, 9:49am UTC](https://community.glideapps.com/t/how-to-select-values-from-other-drop-down/54607/3 "2022-11-21T09:49:35Z")

</div>

Hi,

How to filter ?  
I tried but not coming.

 ![701](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/2/e287f1865044b0084283bd66487040730d289430.png)

---

<div class="post-metadata">

**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:** [November 21, 2022, 10:06am UTC](https://community.glideapps.com/t/how-to-select-values-from-other-drop-down/54607/4 "2022-11-21T10:06:33Z")

</div>

On your Sub Category choice component, use the following:

“Category is Screen → Category”

---

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [November 21, 2022, 10:23am UTC](https://community.glideapps.com/t/how-to-select-values-from-other-drop-down/54607/5 "2022-11-21T10:23:19Z")

</div>

Now it comes like this,

if i select women,it gets the first value from sub category and if i select girl its getting the second value and so on…

 ![702.PNG](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/f/8f02122630c37bfad861e660a61c644f3dab4299.jpeg)  
 ![703.PNG](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/b/4b6d6947e5c4ebc0df43a921c06e0ccb6f84cdf0.jpeg)

---

<div class="post-metadata">

**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:** [November 21, 2022, 10:30am UTC](https://community.glideapps.com/t/how-to-select-values-from-other-drop-down/54607/6 "2022-11-21T10:30:20Z")

</div>

Can you click on the below please, so that the filter condition is expanded, and show me what it looks like.

 ![Screen Shot 2022-11-21 at 6.29.08 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/a/ea90e57c994563e7823a1bc0d5104db88ee15bc1.png)

---

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [November 21, 2022, 10:48am UTC](https://community.glideapps.com/t/how-to-select-values-from-other-drop-down/54607/7 "2022-11-21T10:48:09Z")

</div>

![704.PNG](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/7/f748b5ad6fa91d2e0d1fa1949fea5aa002a5babe.jpeg)

How it find that this sub category is for this main category ?

---

<div class="post-metadata">

**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:** [November 21, 2022, 11:00am UTC](https://community.glideapps.com/t/how-to-select-values-from-other-drop-down/54607/8 "2022-11-21T11:00:11Z")

</div>

Wait… which table is the source of your Choice Components?

Is it this one? 👇

 ![Screen Shot 2022-11-21 at 6.56.26 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/e/9e84198c72f739a07dfed0a536f181cb7f914e9b.png)

Or is it this one? 👇

 ![Screen Shot 2022-11-21 at 6.56.37 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/a/4abaa696720b805f623c204b76931782663b022c.png)

From what you are describing, it sounds like it’s the first one.  
It _should_ be the second one.

The first one - with all the User Specific Columns - is where the choice selections should be written to. That table probably only needs a single row. It looks to me like you have all your data jumbled up.

---

<div class="post-metadata">

**Author:** ![Manikandan\_R](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manikandan_r/32/43482_2.png) [@Manikandan\_R](https://community.glideapps.com/u/Manikandan_R)\
**Post date:** [November 21, 2022, 11:16am UTC](https://community.glideapps.com/t/how-to-select-values-from-other-drop-down/54607/9 "2022-11-21T11:16:05Z")

</div>

Im using the first one ,thats where the choice table selection coming of.

i just updated the 1st table with look like second one and its now working based on screen value.

i added sub category value before like women,girl and born baby and filter as  
main category -\>includes -\>main category

Now its working.I want to know whether it is ok ?
