Hi,
I am managing two different labs (departments) and for me, the best solution is to have all samples, clients, etc. in one place and creating worksheets from the whole sample list and assign analytical services to these samples. But, I need to secure, that analysts from different laboratories will not be able to see each other’s clients, samples, measurements etc.
In other words, I need to find a way, the analyst can see just his own services and samples, that were assigned to them.