Contact in Conthist

[ddeegan]

Hello

I am in the process of a SQL data migration project.

I am transfering the conthist records to another table that will include the contact. The contact may either be the primary (contact1) or a secondary (contsupp) from Goldmine.

Conthist contains the contact in the reference after "oc:"

Is this the only connection to the contact name? or is linkacct, recid, etc used somehow?

Thanks
Dave

 

[M8KWR]

i believe that this is the only link the contact records, which to me seems a bit silly, as if you alter the contact name, then the reference stays the same, and in theory they do not match anymore....

Which when you are trying to design reports based on pulling information from the contsupp table against history entries linked to a contact... I have a solution, but its not 100% acurate though, as everything its only as good as the information put in....

 

[williamkremer]

They are linked like this

SELECT c1.contact as Main, cs.Contact Subs from contact1 c1 join contsupp cs
on (c1.accountno = cs.accountno)
where cs.rectype = 'C'
order by c1.contact

"You cannot hold a torch to another man's path without brightening your own"
Best regards,
Bill