07-23-2014 02:40 PM
I am using SQL server, ACT reader login, to access the database tables for ACT 2010. I was able to access the contacts from the tbl_contact table. I am now trying to link the secondary contacts (tbl_contact.TYPENUM = 2) back to the "parent" contact, but I don't see how. The contactid field for the secondary does not link to any other table. The companyid and companyname fields are NULL for the secondary contacts. I need to "pull" this data and associate it back the parent. Does anyone know how to do this? Thanks in advance. Tony.
07-23-2014 03:02 PM
If you're getting that involved with the database you should use the SSMS to create a field map of the database.
07-24-2014 08:03 AM
There's a table TBL_Secondary.
Secondary ID is the GUID for your secondary contact, CONTACTID is the GUID for the primary contact.