Auto populating a field via Nintex forms and lookup lists.

[scootsie]

Hey everyone, 

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. 

[leighburke · Accepted solution]

Hi @scootsie,

The Lookup function(https://help.nintex.com/en-US/nintex2016/current/#sp2016/Forms/Designer/LookupFunction.htm) should do what you are looking for.