I've added a new custom field but don't know how to access this field on the db table thru sql server? I can see the value in the metadata view and the table view. I need physical access to this custom field so I can update it with some data thru queries.
Custom fields are added to table with a similar name as the main base table. Contacts are stored in the CONTACTS table and custom fields for Contacts are stored in the CONTACTS_CSTM table. The ID_C field in the CONTACTS_CSTM table is the foreign key for the ID in the CONTACTS table.
Copyright (c) 2006-2016 SplendidCRM Software, Inc. All Rights Reserved.