Category, SubCategory and Area are customer specific fields. We have created them as Type "Custom itemized list" fields
Now the requirement is : when user selects a value in Category, then only corresponding SubCategory values to be displayed. Attached is the mapping sheet between Category, SubCategory and Area fields.
E.g.: As per the excel sheet, when user selects "Hardware" in Category, then only "SubCategoryH1" and "SubCategoryH2" should be displayed in the SubCategory field drop down (not all values). Similarly when "SubCategoryH1" is selected in SubCategory field then only "AreaHS1" should be displayed in "Area" field drop-down (not all Area values)
Attached are the screenshots for reference.
Let me know if this is possible in AM?