Table Updates Allowed, expression assistant

Hi,

I am trying to work out an expression to allow users access to certain tables, but can work out how to achieve it.

I have a table called user access, this contains email addressโ€™ and table names.

Each user email will also have a brief description of what they are able to do in each table. i.e Read, Add, Update

The expression I want to achieve is if the useremail is within the table user access, and the column Products is add, the I want the access to be Add Only, or if that same column is Update then it should be set to Add and Update and so onโ€ฆ

Is this achievable?

Kind Regards

0 5 843
5 REPLIES 5
Top Labels in this Space