I have a custom list with 200 records/items and there is a column (lookup) with department names (about 20 department). I want to give access to number of items based on the department. A similar example would be a Contact List with multiple department so Marketing Dept should see only staff details for their dept.
I was thinking of using filters but I think users will be able to access the full list through URL which is not ideal. I could also break the inheritance and assign permission to individual items but that would be very hard to manage when number of items increase.
Are there any other ways to achieve this? Thanks