<div dir="ltr">Coming back to this, I found a distinguishing factor - when the criteria field is a picklist, the 'is empty' doesn't work. It does work for other field types. To get around this, set the operator to 'not equal to' and then select all the options in the value field. <br clear="all"><div><div><div dir="ltr" class="gmail_signature" data-smartmail="gmail_signature"><div dir="ltr"><div><br></div><table cellpadding="0" cellspacing="0" style="font-family:Arial,sans-serif;font-size:14px;color:rgb(51,51,51)"><tbody><tr><td style="display:flex"><b><img src="https://media.glassdoor.com/sql/640156/retail-data-systems-squarelogo-1412104178471.png" alt="RDS Logo" style="width:60px;height:60px;margin-right:10px"></b><div><b>Steve Kenow</b><br><span style="font-style:italic;font-size:12px">Manager, End-User Services and Support - <a href="https://www.rdspos.com/Minneapolis-Minnesota-Grocery-Point-of-Sale-System" target="_blank">RDS MN</a></span><br><span style="font-size:12px;display:inline-block">Direct: (952) 392-2686<br>Office: (952) 934-4001<br>Email: <a href="mailto:skenow@rdspos.com" style="color:rgb(17,85,204)" target="_blank">skenow@rdspos.com</a></span></div></td></tr><tr><td><table cellpadding="0" cellspacing="0"><tbody><tr><td><br><table cellpadding="0" cellspacing="0"><tbody><tr><td><table cellpadding="0" cellspacing="0" style="margin-top:10px"><tbody><tr><td><a href="https://mailtrack.io/trace/link/d5e46ac8cfdec7b8ebdc539696dd45306644b800?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FGrocery&userId=3091118&signature=18b062316c510b1b" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon-Shopping-Cart2.jpg" alt="Icon 1" style="width:30px;height:30px;margin-right:10px"></a></td><td><a href="https://mailtrack.io/trace/link/b0fdfdd837e0d187e174cae0c9479c9b847c4e36?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FQuick-Service%2FPoint-of-Sale-Solutions&userId=3091118&signature=b26cf2b23255a2a2" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon-Burger2.jpg" alt="Icon 2" style="width:30px;height:30px;margin-right:10px"></a></td><td><a href="https://mailtrack.io/trace/link/9c1116af49d5de3a851b38185dbd7ba07d27def2?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FRestaurant%2FPoint-of-Sale-Solutions&userId=3091118&signature=78db9a7d4392c7ed" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icons-TableService2.jpg" alt="Icon 3" style="width:30px;height:30px;margin-right:10px"></a></td><td><a href="https://mailtrack.io/trace/link/c5c6a63b04b163898650fb7e2fdd7312ca923cdf?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FGeneral-Retail&userId=3091118&signature=1ec7a1d9db94a0f1" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icons-Retail2.png" alt="Icon 4" style="width:30px;height:30px;margin-right:10px"></a></td><td><a href="https://mailtrack.io/trace/link/9d0a121b09b0d5e1ba1c5be04c5c2b8d969b7d2c?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FConvenience-Store%2FNCR-Radiant-Convenience-Store-POS-System&userId=3091118&signature=112f29b42fe5a787" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon-Fuel2.jpg" alt="Icon 5" style="width:30px;height:30px;margin-right:10px"></a></td><td><a href="https://mailtrack.io/trace/link/16b4ffb1c4363203009e09666cb41ce82f3a39c1?w=anNrb2xha0ByZHNwb3MuY29t&url=https%3A%2F%2Fwww.rdspos.com%2FProducts-Solutions%2FRDS-Payment-Services&userId=3091118&signature=84ffb1248e80fb55" style="color:rgb(17,85,204)" target="_blank"><img src="https://www.rdspos.com/portals/0/Icon%20-%20Credit%20Card%20processing.png" alt="Icon 6" style="width:30px;height:30px;margin-right:10px"></a></td></tr></tbody></table><hr style="width:240px;height:1px;margin-top:10px;margin-bottom:6px;background-color:rgb(170,170,170)"><div><br></div></td></tr></tbody></table><font size="2">Support Questions/Issues? Email <a href="mailto:rdshelp@rdspos.com" target="_blank">rdshelp@rdspos.com</a> (non-emergencies) or call (952) 934-4002 24/7</font></td></tr></tbody></table></td></tr></tbody></table></div></div></div><br></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Thu, Jun 8, 2023 at 10:38 AM Steve Kenow <<a href="mailto:skenow@rdspos.com">skenow@rdspos.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr">Finding "orphan" Contacts is not exactly hard. They have a field <br>
"Organisation" and if it's empty then the Contact is an Orphan(*).</div></blockquote><div dir="ltr"><br></div><div>Well ... only if you include Organizations as a related module in the report configuration. If you don't include Organizations as a related module, all contacts are returned.<br></div><div><br></div><div>The list filter does work, though.<br></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Tue, Jun 6, 2023 at 3:34 AM Alan Lord <<a href="mailto:alanslists@gmail.com" target="_blank">alanslists@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">No,<br>
<br>
I was just wondering why...<br>
<br>
Finding "orphan" Contacts is not exactly hard. They have a field <br>
"Organisation" and if it's empty then the Contact is an Orphan(*).<br>
<br>
You can simply create a list filter to show these. Ditto with orphan <br>
Service Contracts (except "Related To" could be either a Contact or an <br>
Organisation)<br>
<br>
Al<br>
<br>
* Apart from the n:n relationship in Opportunities - which is a <br>
different relationship<br>
<br>
On 05/06/2023 21:51, Steve Kenow wrote:<br>
> Contacts is the primary module and Organizations is set as a related <br>
> module. Is that how I'll need to adjust?<br>
<br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" rel="noreferrer" target="_blank">http://www.vtiger.com/</a><br>
</blockquote></div></div>
</blockquote></div>