I have a SharePoint site with two lists. One is the 'form' list and includes a bunch of different columns required for the form. The other list is made specifically for lookup purposes and includes a column for purchasing groups and another column for what buyer leads each purchasing group. The form is aimed to complete an order requisition for a client. The place I am stuck is that when a user picks a purchasing group, I want a calculated value to retrieve the buyer associated with that certain purchasing group.
Refer to the picture below for a better idea of what I am trying to accomplish.
Solved! Go to Solution.
The Lookup function(https://help.nintex.com/en-US/nintex2016/current/#sp2016/Forms/Designer/LookupFunction.htm) should do what you are looking for.