Related or associated company (organization) and Super Case table. How to relate the Super Case Table and the Related or Associated Organization.

NETKEEPER^{^{^�}}
nklin1.gif (3727 bytes)
|Home|Products|Demos|Tech Support|Top FAQ list| Help Desk Software| CRM Software|

Related or associated company (organization) and Super Case table. How to relate the Super Case Table and the Related or Associated Organization.
Document ID : 000-000950 Created: 2/23/2005 Last changed on: 2/23/2005
Applies to : v7 v8 NetKeeper CRM, NetKeeper Help Desk

The Related or Associated organization name is stored in the CIMNK table. The Super Case table is the SCDNK table.

To relate the two tables:
*- Relate the foreign key AsscCIMSiteID / AsscCIMSysID fields in the SCDNK table to the primary key fields CIMSiteID and CIMSysID of the CIMNk table.

Example link:
SCDNK.AsscCIMSiteID = CIMNK.CIMSiteID
SCDNK.AsscCIMSysID = CIMNK.CIMSysID

Example SQL:
select scd.SCDSiteID,scd.SCDSysID,scd.Address,cim.Name AS "Related Org." from scdnk as scd
left outer join cimnk as cim ON
cim.CIMSiteID = scd.AsscCIMSiteID AND cim.CIMSysID =scd.AsscCIMSysID
order by scd.SCDSiteID ASC , scd.SCDSysID ASC

This solution text WEB page is automatically generated from your knowledge base and service data by NetKeeper Help Desk Software or NetKeeper CRM software. You can customize the pages to your site's look and feel or even include advertisements.