View: Form Selection Formula
Posted on 2006-05-22
Greetings! I'm looking for some help with a form selection formula. The problem I am having is that not all of the documents that meet my criteria are being returned in the view. I'm looking for documents assigned to my team.
The form name is "Testing Defects"
The field I'm looking for is "Assigned" and may contain multiple values.
In the "Assigned" field, sometimes the common name is used. Other times, the extended name is used in the format shown in my formula below. The form I created is supposed to look for either variation, but does not appear to be working, as I can find examples of documents that meet the criteria but do not appear in my view. I have ruled out spelling errors. Please help me write the formula so that all documents assigned to these people will show up in my view. Thank you for your time! :)
SELECT Form = "Testing Defects" & (Assigned = "Sue Johnson" | Assigned = "Sue Johnson/00/IBM" | Assigned = "John Smith" | Assigned = "John Smith/00/IBM" | Assigned = "Thomas Davis" | Assigned = "Thomas Davis/00/IBM" | Assigned = "Alexander Brown" | Assigned = "Alexander Brown/00/IBM" | Assigned = "Robert Morgan" | Assigned = "Robert Morgan/00/IBM")