11-03-2010 12:34 PM
I've about convinced myself this is a VBScripting project and not something that can be created using Groups. Can someone please confirm or illuminate? (SLX 7.2)
I want to create a Group that shows only Accounts which have NO primary Contact assigned.
11-05-2010 02:56 AM
this is something you can do in a group, but need some SQL knowledge.
I would write a SQL statement showing the accountid of accounts that have a primary contact, and make a group saying where accountid NOT in (select my accounts having primary contact).
The select statement is quite simple in this case :
select accountid from contact where isprimary = 'T'