If I have a field called batch #. I have a second field Yes/No. What is the expression that would cause the second field yes/no to change from yes/no based on if the batch # entered is found in the dataset.
Basically what I want is if a user puts in a batch number they have used previously it will come us saying No. If the batch number hasnt been used it will say yes
