Our application contains records for several hundred customers. Each customer has an account manager assigned to them. (This is a one-to-many relationship, in which each customer will only have one account manager, but each account manager will have many customers.) Account managers should only be able to view/edit their own customers' records when they log in to the application.
In the past, we have managed this by creating a separate view for each account manager, with a filter so that only the records for his or her customers are displayed. However, the number of separate views we had to create and maintain became almost unmanageable. What I would like to do, if it's possible, is to have a single view for all account managers, with a fancier filter that displays the appropriate customer records based on the logged in user. Is this possible? If so, how would I set it up?