Dereference problem in form view

[DaGi07]

Hello guys,
I have my usual most common problem with dereferences… I have an app as budget tracker where I have three tables “Expenses”, “Income” and “Balance” and recently I add the table “subcategory”. When I add an expenses and i select a Category, in the next filed Subcategory i would see only the subcategory related to the Category selected in the form view.

(expenses table)

(Category table)

(Sucategory table)

Please, help me! I know that is a simple things but in this moment i don’t manage to see the solution… maybe i’m too sick

[WillowMobileSys]

This isn’t a de-reference problem but rather a filtering problem.

The expression you should use in the the Valid_If of the Subcategories column in your Expenses table is:

SELECT(Sottocategoria Table[IDSottocategoria], [Categoria] = [_THISROW].[Categoria])

Please adjust the name to match your tables and columns