Formula for creating value dependent select lists

Hi all,

I have a field called CATEGORY with Single select values like "Alcohol, Snacks etc ". For each of these values I want to maintain a SUB_CATEGORY field for example : For Alcohol, sub categories may be Beer, Gin, Whiskey. For Snacks, Sub categories may be Chips, Pringles.

Now my requirement is: I want to create a formula that reads the CATEGORY and only displays the relevant sub categories for that category in the drop down. WHat is the best practise to achieve this.

Thanks a lot in advance.

Regards
Sushmit

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.