KERRIDGE 8.35 REPORTS

Post Reply
toqeer
Posts: 6
Joined: Wed Mar 17, 2010 10:07 am
Contact:

KERRIDGE 8.35 REPORTS

Post by toqeer » Tue May 11, 2010 7:21 am

HI
I want help in making 1 CRM REPORT. I have a report of CRM customer contact history with 2 tables as below:
1- MK- CONTACT HISTORY 1- tarmagic 1
2- MK- CUSTOMER RECORD

i want to connect or link the vehicle record table(MK- VEHICLE RECORDS) in my current report to get the details of cars with customer contact history report.
Can you please help me , how i link vehicle record table in this report .

Your quick response will be highly appreciated

Thanks

keithtempleman
Posts: 12
Joined: Wed Aug 18, 2010 2:11 pm

Re: KERRIDGE 8.35 REPORTS

Post by keithtempleman » Wed Aug 18, 2010 2:26 pm

As you've found you cannot link the vehicle table directly from the target table as they are joined by a many-to-many table called vlink. This contains

CT (company or target)
CTMAGIC (magic for company or target)
EDITDATE
LINKTYPE (S A or D in normal setups)
VEHMAGIC
VEHSTAT (Currrent, Previous)

You'd have to link using CT = T, Target number, then sift through the potential multiple VEHMAGICs. You could use the ki_ routines for this.

Keith

EDIT you could possibly link from the Vehicle Magic held on the Contact record but this will only be present if the contact is of a vehicle-related type.

Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest