10-27-2008 12:04 PM
I have several lookups based on fied attributes. One of which is looking up a company name that "equals to" AND another field "equal to = false" (this is a yes/no) field. I have created several such look ups.
In one case, it is not working since it is selecting companies whose name is correct BUT where is yes/no field is NOT correct.
10-27-2008 01:48 PM
10-27-2008 02:12 PM
Ok -- here goes!
1 field is a yes/no
1 field is the company name.
The query is:
Company equals to "(I put the exact name as it appears in this field)" - this is a common
I created a custom yes/no field named named Opt In, operator is equal to, value is "false" -- this is set to false in the query.
It brings back a list - the majority os which is correct but also brings back contacts where the yes/no is set to "true". There are other contacts within this same company that are not returned but their value is true.
In other words, it is identifying the majority of right contacts but is also returning wrong ones.
10-27-2008 02:39 PM
10-28-2008 09:49 AM