Solved

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

Posted on 2011-03-17
4
667 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:PCIIain
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 30

Expert Comment

by:Mike Lazarus
ID: 35157334
They don't correct directly. Both connect to 1 or more contacts/companies/groups
0
 
LVL 13

Author Comment

by:PCIIain
ID: 35157447
So when they clear an ACTIVITY (and it is therefore flagged as cleared) a copy of this record is put in the HISTORY table?
0
 
LVL 30

Assisted Solution

by:Mike Lazarus
Mike Lazarus earned 50 total points
ID: 35157485
Well, it's not an exact copy.... the user can change items when saving the history
0
 
LVL 7

Accepted Solution

by:
50cal earned 450 total points
ID: 35157502
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
C# InstallShiled - Multiple Projects 3 84
Crystal Reports 9 and Subreports 3 89
Page Break on Change of Field 2 27
Analyze Shared Variable? 7 27
As most of my regular readers and followers know, I do a lot of on-line technical support as well as providing support services to our resellers and ACT! Certified Consultants and one of the things I notice is that I regularly need to ask users the …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question