lookup table only works with administrator user (v2021)

Kpta · Post by **Kpta** » Thu Mar 21, 2024 4:27 am

Hello,
I'm using a static security level and I came across the lookup table only working for the Administrator user. I deleted the entire project and generated it again, checked all updates and permissions, without success. It was working normally.
Any user other than the administrator, lookup table does not show the items.

mobhar · Post by **mobhar** » Thu Mar 21, 2024 9:37 am

Make sure you have already given the lookup permission for your desired user level.

Kpta · Post by **Kpta** » Thu Mar 21, 2024 8:58 pm

Thanks for the feedback.
I've checked everything, the permissions have been checked and they are ok.

The user has access to the table, can include, change and delete, that is, they have full access to the tables. The problem is only with the lookup table.

yinsw · Post by **yinsw** » Fri Mar 22, 2024 12:33 am

Table A
Table B (Use as Lookup table in Table A)

You must assign Lookup permision for Table B, not Table A

Kpta · Post by **Kpta** » Fri Mar 22, 2024 1:54 am

All permissions have been given and it still does not show the table items, there are 4 lookup table fields for different tables. It was working, then suddenly it stopped working. I have already reviewed the entire routine, permissions, parameters without success. The item linked to the lookup table appears in the preview.

mobhar · Post by **mobhar** » Sat Mar 23, 2024 11:36 am

Are you sure you are using Static User Level Security and not Dynamic User Level Security?

mobhar · Post by **mobhar** » Tue Mar 26, 2024 9:18 am

Has your problem been resolved by using Dynamic User Level Security?

Kpta · Post by **Kpta** » Tue Mar 26, 2024 9:59 pm

Yes, now I'm making some adjustments.
How can I change the table name in the permissions for routines?
How do I apply alternating row color to the permissions "table"?