You need to sign in to do that
Don't have an account?

Junction object for two standard objects.
i) Whether i can able to create junction object for opportunity and user objects?
ii) Is there a way to select two values in the lookup?
Kindly advice.
i) You cannot create a junction object for opp and usr objects because you cannot create a master-detail field on junction object to User object.
ii) No you cannot select 2 values in the lookup.
I agree with Srikanth, and it is not possible to create master detail relationship between any custom object and user. But you can create master detail relationship between Opportunity and any custom object. After that you can create a lookup relationship of user on custom object. Creating these relationship will also resolves your problem of having a many-to-many relationship between User and Opportunity.
If it not resolves your problem then let me know the precise requirement so I can suggest more accurately.
P.S : You can not select two values in lookup.
Thanks
Ankit Arora
Blog | Facebook | Blog Page