Multiple user levels (v2021)

[sclg]

Say I have user level A which allows read access to table 1
and user level B which allows read/write access to table 2.

If I give a user level A access, they can see table 1.
If I give them Level A AND level B, then they have R/W access to table 2 BUT they can no longer see table 1 - not even in the menu.

User level B ALSO allows read access to table 1.

If I set the user to EITHER level A or B, they can read table 1, but if I set them to BOTH levels, then they can't.

This seems wrong to me. Am I doing something wrong?

[mobhar]

You better create another user level which have your desired permissions to the tables that suits your needs.

In addition, you may use Recordset_Selecting server event to allow access records for that user level above.

[sclg]

I can do that but it would be nice to know how multiple levels are supposed to work.