Group Visible for more than one conditions

I have two tables:

One User-Roles that describes user’s roles.
The next one is User that has the name of users and their user roles that taken from table User-Roles

How can I make a group visible for more than one user-role type of user.
Fow example what If I want a specific group to be visible by users only in Marketting and Cutting department but not in Packing?

If I use the “or” then one cancels the other!

15

This topic was automatically closed after 70 days. New replies are no longer allowed.