We have a database with clients and I would like to give casemanagers access to their own clients only. I van make a filtered view for every casemanager, but any other casemanager can still open that view. Is there any way to get this done?
It is not possible to completely prevent a collaborator from viewing other records. All collaborators on a base can view all of the data in the base. There are some workarounds that involve using multiple bases and synced tables, but you loose the ability to edit the original records.
Some people use a portal, such as miniExtensions or Stacker to provide people with limited access.