I have a form where i'm trying to filter the list lookup. I have to filter data between two SharePoint list so this would require multiple layer of filter.
On Control Settings - List Lookup, i can only filter the data once whereas i need multiple filter.
Is there any other way to do this?
Thanks for your reply. I'm not trying to cascade drop down.
I have tried to describe the issue below.
List 3 (Nintex Form)
What i have done:
What i am trying to do:
In Nintex Form, Batch No. drop down should only show "BN12345".
so I understand it this is a static filter, ie. filter doesn't change on other form controls values.
then I'd suggest to create a view on list with all these filtering conditions an then configure lookup control to filter by 'Source view'