Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Contact in Conthist

Status
Not open for further replies.

ddeegan

Programmer
Jun 17, 2002
193
US
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

 
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....
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top