Hi all.

We have SLX LAN v7.2.1.

We are running into an issue, we recently created a table in the Architect (C_myTable) it has a one-to-one relationship with the ACCOUNT table. The table fields are: ACCOUNTID, FreightCompany, Status

When we try to create a group (in Contacts) whose criteria is that the Status field = ACTIVE it doesn't find the data in the table. In query builder, we tried selecting the field then when to (=) equal to and clicked the Browse button, nothing came up. But if we go to the same table on SQL it has data. This happens for everyone except the Admin.

Any ideas why?

Thank you in advance.

Nevermind I figured it out. When I created the custom table it added the "SECCODEID" field, I simply removed it from the table and it's ok now.