# I created a RELATION column but my component cannot see that column. Why? **URL:** \ **Category:** Ask for Help\ **Created:** [November 7, 2024, 9:02pm UTC](https://community.glideapps.com/t/i-created-a-relation-column-but-my-component-cannot-see-that-column-why/77737 "2024-11-07T21:02:47Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![mbraunperu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mbraunperu/32/83676_2.png) [@mbraunperu](https://community.glideapps.com/u/mbraunperu)\ **Post date:** [November 7, 2024, 9:02pm UTC](https://community.glideapps.com/t/i-created-a-relation-column-but-my-component-cannot-see-that-column-why/77737/1 "2024-11-07T21:02:48Z")
I have categories, and each category has many subcategories. I created a relation column in the Category table. The column rightly shows the many Subcategories for each Category. But when I add a Choice component and link it to the correct source table, I only see one field: Category. I dont see the relation field Subcategory. Why? ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [November 7, 2024, 9:03pm UTC](https://community.glideapps.com/t/i-created-a-relation-column-but-my-component-cannot-see-that-column-why/77737/2 "2024-11-07T21:03:48Z")
You need a lookup column to be able to take a column value from a relation. ---
**Author:** ![mbraunperu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mbraunperu/32/83676_2.png) [@mbraunperu](https://community.glideapps.com/u/mbraunperu)\ **Post date:** [November 7, 2024, 9:05pm UTC](https://community.glideapps.com/t/i-created-a-relation-column-but-my-component-cannot-see-that-column-why/77737/3 "2024-11-07T21:05:20Z")
I tried that. I created a lookup column that rightly shows the items for the category (just like the relation column does). And still, from my component, I cannot see that column either. ---
**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\ **Post date:** [November 7, 2024, 9:06pm UTC](https://community.glideapps.com/t/i-created-a-relation-column-but-my-component-cannot-see-that-column-why/77737/4 "2024-11-07T21:06:52Z")
Can you show screenshots to help me visualize your tables please? ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [November 7, 2024, 9:13pm UTC](https://community.glideapps.com/t/i-created-a-relation-column-but-my-component-cannot-see-that-column-why/77737/5 "2024-11-07T21:13:59Z")
Is the relation a simple or match multiple? It would need to be single to work on the choice component. ---
**Author:** ![mbraunperu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mbraunperu/32/83676_2.png) [@mbraunperu](https://community.glideapps.com/u/mbraunperu)\ **Post date:** [November 7, 2024, 9:17pm UTC](https://community.glideapps.com/t/i-created-a-relation-column-but-my-component-cannot-see-that-column-why/77737/6 "2024-11-07T21:17:56Z")
Sure. Thanks in advance! ![screen](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/b/5bcc110447c2dc274418ee9aab199d82bc73c16c.jpeg) ![DB](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/2/12592e26f7fc989c7f62e7107471883cda2bccd8.jpeg) ---
**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:** [November 7, 2024, 9:23pm UTC](https://community.glideapps.com/t/i-created-a-relation-column-but-my-component-cannot-see-that-column-why/77737/7 "2024-11-07T21:23:26Z")
Are you trying to refer to a relation from inside the form? That won’t work because you haven’t written the category to the table until after the form is submitted. Change your source table for the subcategory choice component to be the Subcategory table. Then apply a filter based on the screen value of the chosen Category. ---
**Author:** ![mbraunperu](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mbraunperu/32/83676_2.png) [@mbraunperu](https://community.glideapps.com/u/mbraunperu)\ **Post date:** [November 7, 2024, 9:40pm UTC](https://community.glideapps.com/t/i-created-a-relation-column-but-my-component-cannot-see-that-column-why/77737/8 "2024-11-07T21:40:40Z")
Just in case, I am not trying to write anything into the Category or SubCategory tables. However, I followed your filter advice and it worked! Thank you very much! ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [November 14, 2024, 9:40pm UTC](https://community.glideapps.com/t/i-created-a-relation-column-but-my-component-cannot-see-that-column-why/77737/9 "2024-11-14T21:40:41Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.