I am trying to display data in repeating groups but cannot understand how to specify what data I need.
Here is a screenshot of a database
Problem is that I need to display in a repeating group just All subcategory names that have main category “Animal” so it would just Display in the repeating group Cat, Dog, Other animals.
I have set the repeating groups Content to be “Sub category” type.
And to perform a search for “Sub category” type.
And in the repeating group, I have added a textbox that displays current cells Subcategory.