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

Iain

PCIIain

Asked: 2011-03-17

Advertise Here

2 Solutions

LVL 30

Mike LazarusAct! Evangelist - CRM ConsultantCommented: 2011-03-17

They don't correct directly. Both connect to 1 or more contacts/companies/groups

LVL 13

PCIIainAuthor Commented: 2011-03-17

So when they clear an ACTIVITY (and it is therefore flagged as cleared) a copy of this record is put in the HISTORY table?

LVL 30

Mike LazarusAct! Evangelist - CRM ConsultantCommented: 2011-03-17

Well, it's not an exact copy.... the user can change items when saving the history

LVL 7

50calCommented: 2011-03-17

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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Expand your skills with this month's free Premium course.

How do I connect the activity table and the history table in ACT under crystal reports

Join & Write a Comment Already a member? Login.

Featured Post