I have a lookup list in SharePoint with 3 columns. "Category", "Sub-Category", "Data". Each Category has only one Sub-Category value, each Sub-Category has only one Data value, there are no duplicates anywhere in the list. I am using the new responsive forms.
I would like to be able to select the Category and the Sub-Category and Data field auto-populate on the form. I have managed to do this one level down, i.e "Category and Sub-Category", but not been able to populate the Data. I have been using Rules to accomplish this.
The rule for Sub-Category: lookup("LKCategory","Category",parseLookup([Form].[Category]),"SubCategory")
The rule for Data: lookup("LKCategory","Category",parseLookup([Form].[Sub-Category]),"Data")
I have read that maybe 2 lists would enable this to work, List1: Category, Sub Category. List 2: Sub-Category, Data. However, for updating purposes, feel it would be better in 1 list.
Is there any way that I can do this without using Javascript, or potentially two lists.
Appreciate your help!