Missing relations

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

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)

As a new user, I cannot publish some screenshots. Here’s a link of the image

Make sure you don’t have any extra spaces around your category name. They have to match exactly for a relation to work.

2 Likes

Yes, it’s working thanks @Jeff_Hager :pray:

2 Likes

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.

2 Likes

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.