Lookup Select Box values display Null in the native UI and not visible on the portal

[Moe13]

Hello and thank you in advance for your help. 

I created a new table with a list of locations to use for a variable in a catalog item. I removed the created ACL role to  "read" the table and selected display. This particular catalog item was using a previous custom table but the client asked to created a new table for this variable. The problem I'm having is, the values are not visible on the portal (its there but you can't see it) and on the backend with the "try it" button, they are all listed as null. Please help, what am I doing wrong? 

[-O- · Accepted solution]

The ACLs look OK, seem to be standard ones.

However I seem to see a field labelled Organization - singular (in the 1st screen shot).

But Lookup label field(s) (in another screen shot)  contains a field name in plural - u_organizations!

Are you sure u_organizations is the correct, valid field name?

[-O-]

Better add the column Column name to related list Table Column on the Table form and make sure what is the name of the field labelled Organization.

[-O-]

Totally unrelated, but as a best practice, both table names and column names should be singular.

An exception should be columns of type List - which can be plural.

[Moe13]

You are right, the Lookup label field was plural when it should be singular, good catch. Thank you for pointing that out. I appreciate your help and eyes. 

[-O-]

You're most welcome. 🙂