09-29-2013 06:47 AM
I'm trying to locate the table which holds user added fields for the contact record. I've looked at all the contact tables ( i.e dbo_CONTACT_SOURCE etc) but none of these hold user created fields. Can anyone suggest a table name where they might be ?
09-29-2013 07:13 AM
Sorry - I've noticed they appear at the end of the standard contact fileds in dbo_TBL_CONTACT. For example CUST_ContactStatus_1233456789 where 12345... etc seems to be a random generated string. The field is created as "Contact Status". I was fearful there might have been some more complex approach to storing custom fields.