Hi, I have a specific query around the use of Access Groups, that has got me a bit stumped at the minute, and would welcome some advice.
As I understand the setup at the minute, a user can only belong to a single Access Group. However, I have a situation to handle whereby users can belong to multiple Access Groups at the same time (and is therefore able to see all records for those Groups).
For example, supposing 3x Users (called Alfred, Bernie & Charlie) and 3x Groups setup (IT Support, IT Maintenance & IT Provision)
- Alfred can belong to both IT Support & IT Maintenance
- Bernie can belong to both IT Support & IT Provision
- Charlie can belong to both IT Maintenance & IT Provision
Th groups have to be at a flat level (I.e. cannot use inheritance by cascading them) because of the complexities involved with many multiples of Access Groups and Users - the above is just a simple example.
Is there a way this can be simply achieved ? Any pointers would be very helpful