Hi all.

We have SLX LAN v7.2.1.

I created a custom table (C_myTable) but nobody can see the values in the table EXCEPT the Admin. So if someone tries to do a query using Query Builder to let's say, see the accounts in that table that are in CA it doesn't return anything. It seems as if the table data is hidden to everyone except the Admin.

How do I make that table available to everyone? In the query builder you can see the C_myTable in the list but when you try to look up the data in some of the fields it comes back blank.

It has a 1:1 relationship with the ACCOUNT table.

Thank you in advance.

You need to delete the column seccodeid that is in this table (SLX puts it in automatically). If it's there, you'd have to choose to populate it as SLX will not. If it isn't - then the security model applies (which is why Admni can see it).

That was it. Thanks Mike!