I want to create a database of around 1000 customers.
There are around 50 sales men responsible for managing different customers based on his geography/territory.
Each Sales person needs to maintain certain master data, customer status and images, etc. for each customer that he’s responsible for.
No sales person should be able to edit other person’s customers. (So access needs to be controlled based on geography/territory of the customer).
But centrally, I should be able to see consolidated… where each customer is standing.
How do I go about this?