Skip to main content

I have a list containing 'Name', 'ID' and 'Status' columns. In 'Status' column, I have three values "Pass","Fail","NA".

Now my requirement is, I want the 'Name' of students in a drop-down whose 'ID' lies between 15 to 20 and 'Status' is not "NA".

 

Any help will be much appreciated. 

@AmanG ...Try to create a view in your list using your filter parameters (unless your filter parameters are not dynamic) and use that view in list lookup control on your form.


Thanks @kunalpatel , filters are actually dynamic.

Reply