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.
Solved! Go to Solution.
@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.