# Missing relations **URL:** \ **Category:** Ask for Help\ **Created:** [April 21, 2022, 12:32pm UTC](https://community.glideapps.com/t/missing-relations/41018 "2022-04-21T12:32:32Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![A-Keating](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/a-keating/32/41679_2.png) [@A-Keating](https://community.glideapps.com/u/A-Keating)\ **Post date:** [April 21, 2022, 12:32pm UTC](https://community.glideapps.com/t/missing-relations/41018/1 "2022-04-21T12:32:32Z")
Hello, I want a create directory app with this structure: - A category has many sub-categories - A sub-category has many activities When creating a relation **only one category can find the sub-categories** (the second one) and I don’t understand why. Anybody would have an idea? (I’ve made sure to have the same wording everywhere ) Thanks ---
**Author:** ![Luther](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/luther/32/17929_2.png) [@Luther](https://community.glideapps.com/u/Luther)\ **Post date:** [April 21, 2022, 1:04pm UTC](https://community.glideapps.com/t/missing-relations/41018/2 "2022-04-21T13:04:12Z")
Hi @A-Keating, Welcome to the community, May you please post some screenshot of your issue so that we can have a better understanding of where the issue may be… Did you make the relation a multiple relation? Is the wording of subcategories exactly the same in both tables? (Relations are case sensitive) ---
**Author:** ![A-Keating](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/a-keating/32/41679_2.png) [@A-Keating](https://community.glideapps.com/u/A-Keating)\ **Post date:** [April 21, 2022, 1:10pm UTC](https://community.glideapps.com/t/missing-relations/41018/3 "2022-04-21T13:10:01Z")
As a new user, I cannot publish some screenshots. Here’s a link of the image > **[Capture d’écran 2022 04 21 à 14.29.28](https://freeimage.host/i/capture-decran-2022-04-21-142928.VNPmFe)** > > Image Capture d’écran 2022 04 21 à 14.29.28 hosted in Freeimage.host > **[Capture d’écran 2022 04 21 à 14.30.23](https://freeimage.host/i/capture-decran-2022-04-21-143023.VNPpcu)** > > Image Capture d’écran 2022 04 21 à 14.30.23 hosted in Freeimage.host ---
**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:** [April 21, 2022, 2:17pm UTC](https://community.glideapps.com/t/missing-relations/41018/4 "2022-04-21T14:17:35Z")
Make sure you don’t have any extra spaces around your category name. They have to match exactly for a relation to work. ---
**Author:** ![A-Keating](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/a-keating/32/41679_2.png) [@A-Keating](https://community.glideapps.com/u/A-Keating)\ **Post date:** [April 21, 2022, 7:20pm UTC](https://community.glideapps.com/t/missing-relations/41018/5 "2022-04-21T19:20:54Z")
Yes, it’s working thanks @Jeff_Hager🙏 ---
**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:** [April 22, 2022, 12:45am UTC](https://community.glideapps.com/t/missing-relations/41018/6 "2022-04-22T00:45:45Z")
To take this to the next level, add a RowID column to your Categories table, and use that as a CategoryID. Then when you add a sub-category, add the CategoryID instead of the Category name, and use that in your relations. This will give you a much more robust solution. ---
**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:** [April 23, 2022, 12:46am UTC](https://community.glideapps.com/t/missing-relations/41018/7 "2022-04-23T00:46:38Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.