08-26-2009 10:12 AM
I created a custom table that has a 1:1 relationship with the ACCOUNT table.
When signed in as an end user and I am in query builder and I select a field from this custom table and click the browse button to view the data in the particular field it comes out blank.
Yet, this does not happen when I am signed in as the ADMIN, I can see the data when I click on the browse button for a field in the custom table.
The custom table was created in the Architect through the Database Manager.
What could be happening?
08-26-2009 11:17 AM
Which version of SalesLogix?
I'll bet that the SECCODEID in the 1:1 table is null.. or not the same as the ACCOUNT.SECCODEID
08-26-2009 11:42 AM - edited 08-26-2009 11:45 AM
A simple SQL update. If you use sync.. make sure you use ExecuteSQL in the admin...
Can also code it in VBScript.
Looking back I would have added the fields to the main table and not do a1:1. In fact, the recomended best practice is to NOT create 1:1 tables.
08-26-2009 02:35 PM