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?
You need a lookup column to be able to take a column value from a relation.
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.
Can you show screenshots to help me visualize your tables please?
Is the relation a simple or match multiple? It would need to be single to work on the choice component.
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.
2 Likes
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!
2 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.