Relationship Tab 1

[SGP1]

Hi - having now upgraded to 8.1 PE I'm struggling with the following query as I have neither a technical background or experience of SQL -

as a debt recovery company, we create a record for our clients and attach their debtors via the relationship tab(personally we think the old Org Chart was better)
- from the date the last additional contact was added, I should be able to tell if our client has sent any further accounts for us to deal with
- should no new contacts been added for say a period of 2 months, we need to contact our client

=========so far my only solution does not work as the new contact does not show in the History when added- if it did then I could muddle together an AP---------I'd be grateful for any help

Mel F

 

[MIChad76]

This query should work... Change the portion from '20070601' to the date range you're looking for. Also, you can put the Org Chart back to where it was in previous version of GoldMine by right-clicking within the relationship tab and uncheck 'Show Relationship Tree in Tab'.

select company, phone1, city, state, zip, key1 from contact1 where accountno not in (select accountno from contsupp where contact in (select CONTACT from contsupp where substring(contsupp.city, 9, 8) > '20070601' and rectype = 'O' and ext = '6') and ext = '1') and accountno in (select accountno from contsupp where rectype = 'O' and ext = '1') order by company

---
Chad Smith
michad76@gmail.com

Check out the GoldMine Blog at

http://www.thegmblog.com

MCP - Microsoft SQL Server
Crystal Reports Certified Professional
GoldMine Certified Professional
Microsoft CRM Certified Professional