I did use this post as a reference: https://community.nintex.com/t5/Nintex-for-SharePoint/How-do-I-filter-the-values-in-a-choice-column-...
I used the solution above on a form I am working on. In the post Chris mentions that for the main category selection ("Meals") "You could make this more dynamic by using a lookup field if you want" in his post. So I went ahead and created a third column where the value of the choice field is calculated, since you cannot do a list lookup on a choice field.
I was able to pull the data but not the way I was expecting. I think I need to filter it but not sure how.
I have a main list called Web Delivery. The second list is called WDSubCategories. The "Request Type" is the main category choices. Someone chooses a Request Type which then filters the secondary list "Sub Category Type" which is a list lookup on the WDSubCategories list.
I can get it to work correctly when the Request Type choice field is in the main list (WebDelivery).
If I do a list lookup for the calculated field in the second list (so I don't have to maintain the choice field in 2 different lists), this is what is presented:
Would anyone know how to filter this so I only see 1 type each?
Solved! Go to Solution.
Thank you. I did review the post. While I can understand how you are doing this, I don't think it's easily understood or easy for others to update and maintain. I prefer the 2 list approach, as it's easier for others to understand and maintain.
That doesn't make sense to me! Did you read the post link that I mentioned above? If I can filter the subcategory (which works exactly as stated in the post link), there should be a way to filter the main category to 1 choice each:
At this point, I am going to create a third list for the "RequestType" and do a list LookUp from that list to the main list.
I accomplish the following by doing it this way:
* I maintain the RequestType in 1 list
* I maintain the SubCateogries in 1 list
* I do a list lookup to both lists from the Main list for each.
I believe this is the best solution.