Cannot view data in custom table in query builder - SLX LAN v7.2.1

[SLX_User]

Hi all.

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?

[RJLedger]

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

[SLX_User]

LAN v7.2.1

How can I check the secodeid for the custom table and match that to the ACCOUNT table secodeid?

[RJLedger]

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. 

Message Edited by RJLedger on 08-26-2009 02:45 PM

[SLX_User]

I recreated the table and instead of making it 1:1 I made it 1 to many and it works fine now.

[RJLedger]

1:m tables are not secured and do not have a SECCODEID field. So it works because there is no security.