I have values on an object called Departments that I wish to reference on the User object. I have a junction object set up between the User and Department objects which has a Master Detail relationship for Departments and a Lookup relationship for the Users.
I want to pull the assigned department from Departments over to a field on the User Record, along with a couple of other fields that are represented on the Department object). I would like to reference this information such that if we change a user's department on either the User or Department object, the related fields are updated on the User record.
Am I headed down the right path? Is there a different\better way (than the junction object) to achieve this?
Thanks much!
Michelle
6 件の回答
If a user can only belong to one department, then your best bet is to have a lookup on Users to the Department object. That way
- Each user can only belong to one department
- A department can have multiple users
You can then use formula fields to pull down the values from the department to the user
