We run a Lab and are hoping to build a heireachy where certain Sales managers will be able to see revenue activity for all of their salsepeople. I am not sure how to do this. Any advice will be appreciated.
You can build a permissions table, where salesperson or sales territory is the primary key and sales manager is another field in the table. Then bring these fields in as a lookup field in the tables where your revenue data lives - at that point you can either use role permissions or report filters to show the relevant data to sales persons and sales managers. Using permissions is less work but also less flexible.