[SOLVED] Lookup Wizard with 2 conditions in Where expression
This topic is locked
[SOLVED]
Lookup Wizard with 2 conditions in Where expression
9/18/2011 11:52:07 AM
ASPRunnerPro General questions
D
dorlisa author
Hi All, I have a field that looks up folks in my "roster" table and displays there name to select from. I added this "Where" statement ("Title = 'ASOM'") to identify these folks by there title and it works, but I need to add a second condition in that "Where" expression. I added this ("Title = 'ASOM'" OR "Title2 = 'ASOM'") and it doesn't work. Can you tell how I can get field to list folks who have the same title whether it's in "Title" or "Title2"? Thanks,