Community
Showing results for 
Search instead for 
Do you mean 
Reply

Relationships Dashboard

Bronze Contributor
Posts: 1,275
Country: USA

Relationships Dashboard

Just built this for a client and thought I'd share it here.  This is a SQL string to build a dashboard showing contacts with relationships.  It's a 4 column dashboard, contact one, role, contact 2 role, contact 2

 

Select C1.CONTACT,
R.CONTACT1_ROLE,
R.CONTACT2_ROLE,
C2.CONTACT
From dbo.CONTACT C1
Inner Join dbo.CONTACT_CONTACT R On C1.CONTACTID = R.CONTACTID1
INNER JOIN dbo.Contact C2 ON C2.ContactID=R.ContactID2

 

 

Patricia Egen
Certified ACT! Consultant, Trainer, Developer
www.egenconsulting.com
(423) 875-2652

Follow us on:


Visit our Popular ACT Wizards Page Wizards Here!