Problems with conditional display of fields in food ingredients database

I have checked the synthax over and over but can't make this work...

I want to create categories and sub-categories but, in order not to crowd the input screen, to display the sub-category only when the correct category above is selected.

The main Category can be Seafood, Meat, Vegetable, Dairy or Dry Store. For each of those I have created an additional field e.g. Dairy Category (eggs, cream, milk etc.). I also create sub-sub categories as needed (e.g. seafood/shellfish/crustaceans/lobster).


So I am applying a conditional test to display a sub-category as needed. For example the Seafood sub-category (fish/shellfish) will only appear if the Seafood main category is selected. The logical test is: Category = "Seafood"

Well it's just not working. I've tried both visual and text editing, my sub-categories just won't appear.

Anything I should do? Is this approach of many sub-categories optimal? (versus, say, sub-tables which I don't really understand!)


Many thanks for any insight




Ninox Profile

Dear François, 

If it is a simple Choice field (only one selection possible) you need to use the formula in the following way: 


text(Category) = "Seafood"

if you ask for the text value of the choice



Category = 1 

if you ask for the index number of the choice.

Kind regards, Jörg