Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2011-03-17
4
Medium Priority
?
676 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 200 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 1800 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

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…
Progress
Introduction to Processes
Suggested Courses

610 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