My company has 60 branches across USA. Every user in Salesforce.com needs to be assigned to a branch. I have a custom object for branch that houses branch data (address, phone, fax, name, region etc). It looks like I am not able to add a lookup relationship in User as a custom field so that I can assign every user a branch.
So, what I thought I could do alternatively is link branches and users. I decided to create a junction object with two master detail relationships. One with user and second one with the Branch custom object.
However, l can't even do the junction object since the User object is not available in the drop-down list for master-detail relationship. I believe there must be some reason behind this design but this creates a problem for me.
Since the company keeps realigning branches and opening new ones, closing old ones etc all the time, creating a role hierarchy for 60 branches is not feasible.
