Hi @MultiTech_Visions (Matt I think?)
Thanks for the response. I understand what you are saying and it is helpful, and would work fine if I just had a single user type who should have the permission. Or if I just had one menu item to show/not show.
However, my problem is that I have multiple users who should only see certain rows on the menu and the App will need to look in different columns to find the permission.
The menu looks like this:
Walls & Dec
and the User Table heading has the same text horizontally like this:
[USER] [MEP] [Walls & Dec] [Install] [Final]
In this example, when Darryl looks at the Menu View he should not see MEP.
But when Clarice looks at the Menu view she sees all items.
Even if I use the current user slice as you have suggested, I need an array type expression in the Menu Table to show a row by matching it to a column on the User Table.
Is there an expression that tells the App what column on the user table to look in based on the value in [MENU ITEM]?
Thanks in advance for any suggestions.