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 )
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.