Page 1 of 1

lookup table only works with administrator user (v2021)

Posted: Thu Mar 21, 2024 4:27 am
by Kpta

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.


Re: lookup table only works with administrator user (V2021)

Posted: Thu Mar 21, 2024 9:37 am
by mobhar

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


Re: lookup table only works with administrator user (v2021)

Posted: Thu Mar 21, 2024 8:58 pm
by Kpta

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.


Re: lookup table only works with administrator user (v2021)

Posted: Fri Mar 22, 2024 12:33 am
by yinsw

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

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


Re: lookup table only works with administrator user (v2021)

Posted: Fri Mar 22, 2024 1:54 am
by Kpta

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.


Re: lookup table only works with administrator user (v2021)

Posted: Sat Mar 23, 2024 11:36 am
by mobhar

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


Re: lookup table only works with administrator user (v2021)

Posted: Tue Mar 26, 2024 9:18 am
by mobhar

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


Re: lookup table only works with administrator user (v2021)

Posted: Tue Mar 26, 2024 9:59 pm
by Kpta

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"?