Depended Filter and accept new values

[pcakhilnadh]

I have four depended filter

• Main Category
• Sub Category
• Sub Sub Category
• Sub Sub Sub Category

So depends on main category I need to filter sub category.

I have used folllowing formula in the Valid If property of Sub_Category

SELECT( category[sub_category] , [main_category]=[_THISROW].[main_category])

I was able to filter the sub category but I was not able to enter new values into sub category.

I wanted to filter the sub category based on the category1 also I wanted to enter new value to category 2 .

More Details

my sub_category

formula in sub_category

View I am getting to enter details

Here I wanted to enter new values also show a filtered dropdown based on the category one selection