so right now I have a Database showing all records always.
Now I am having several Departments, and I would like to have each department only being able to show their records.
The way I thought of doing this was creating a layout for the department and then establishing a Priviledge set that only allows to see that layout, instead of the all contact layout.
I created a self-joined relationship but am only showing records that have the same department.Then I duplicated the layout but changed the shown records to the according table occurance.
My problem is that all records are shown in the new layout, just that all those who are not of the department are empty!
Better ways to do this? Or additional steps that will fix the problem?