Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.
Solved
How do I connect the activity table and the history table in ACT under crystal reports
Posted on 2011-03-17
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
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
[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
So when they clear an ACTIVITY (and it is therefore flagged as cleared) a copy of this record is put in the HISTORY table?
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.
There are link tables between
Contacts <-> History
Contacts <-> Activities.
50cal.
Featured Post
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…
Suggested Courses
Course of the Month7 days, 18 hours left to enroll
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.