11-04-2010 10:51 PM
I seek help on how to link opportunity table with contact table.
Last time when i have 2008 ACT premium, I manage to link the opoorunity table with contact
table with out any problem using OLE .
Now i am upgrade to sage ACT premium 2011 , i am unable to find the contact table variable name " CONTACTID "
for me to link to opporunity table variable "OPPORTUNITYID". ( i am able to locate the
OPPORTUNITYID Variable ).
Hope some one can tell me where is the CONTACTID ? I already search all contact table , and unable to
Second questions is , i also need to link the activity table with contact table. On activity table
i manage to locate the variable name "ACTIVITYID" From ACTIVITY table , but i am also unable to
find variable from contact table which allow me to link . Hope some one can help me please.
11-04-2010 10:57 PM
11-07-2010 10:33 AM
There's a data dictionary that installs with the ACT! program. Try checking there.
11-21-2010 12:33 PM
11-21-2010 12:41 PM
Maybe try this ACT! Knowledge Base article -
11-22-2010 07:50 PM
Hi mike & Mwood,
Thank you for your reply , i manage to download all the 3 file.
Some time back Mr Bill, he is Copper Super Contributor , sage developer. he help me on below post , which i still remeber. apprecaited very much for his help till today . except i still waiting for solution on how to link activity with company.
He mentioned as below :-
Unfortunately you cannot report on Activities as these are not exposed in the ACT! OLEDB Reporting Provider 1.0.
After listen to his advise , i have wait , and now i got ACT ver 2011 , and i still unable to get the activity ID that link with contact. can some one advise me how to do it ?
By the way i notice Mr Bill last log into this forum is jan 2010 , any one know where it mt bill still with sage ? apprecaited if you can share with me. as i am still struggle with how to link activity with contact and company.
when i call ACT singapore , i was told that they no more support ACT , and refer me to solar sys , and when i contact them , they are not aware of how to link., and i ready seek help on this.