How to open a custom table for everyone to view/edit

booher04
Tera Guru

I have created a custom table for a lookup select box field on a Catalog Item form.  The form/field work fine for me and work as intended, however when a normal user goes to the form and tries to select a user from the field it's blank and says none.  I know this is due to permissions on the table itself, but I need to get it set so that anyone can select from that field on the form. The table is u_macd_approvers and the field is it_director.

 

find_real_file.png

find_real_file.png

 

 

 

 

1 ACCEPTED SOLUTION

Mike Patel
Tera Sage

Create Read ACL for your custom table and don't add any role so everyone can see the record in drop down.

View solution in original post

5 REPLIES 5

sahana13
Tera Contributor

Check ACLs for the referenced table (u_macd_approvers) and make sure that there is no any roles/conditions/script in it.