A Dynamic List Based On Enum Value Selected

[AbdirahmanOsman]

Hi All 👋,

If i had a data type which is an enum and is called sports and i had a list of sports e.g. Running , Basketball , Tennis Swimming.

Then i had another list of a set of sub categories on each sport e.g. 100 m relay , 100m sprit, long distance , basketball dribbling , basketball shooting , tennis 1 to 1 , tennis 20 minutes.

I want when a user selects basketball only the basketball exercise/categories to come up not the other values.

Please can anybody help 

Thanks

[Swoopy]

Try this expression in valid-if of column [sub categories]

SELECT(sport[sub categories], [sport]=[_THISROW].[sport])   

[AbdirahmanOsman]

Hey Swoopy,

It is reading the formula but i can't seem to generate 100m sprint from when i select running on the sport's category.

Thanks

[Swoopy]

Please recheck there's expecting row containing:

 ?sport?   100m splint