How do I connect the activity table and the history table in ACT under crystal reports
Using ACT! version 12, I can see the activity table and the history table. I have determined that a 'history' record from the history tab contains data from both of these.
I am using the OLE/DB Provider v 2.0 from Act in Crystal Reports to report on this information, but am unable to find the joining field/table which connects activity to history.
Can anyone tell me where the relationship is defined. Thanks
As far as I know there is no link table between Activities and History. When you complete an Activity it creates a history item but it does not retain a link between the two, you can demonstrate this by un-clearing and re-clearing an activity - it will not update the history entry but create a new one.
There are link tables between
Contacts <-> History
Contacts <-> Activities.
50cal.
0
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.