+ Start a Discussion
san5augsan5aug 

Many to many relationship with two lookup relationship

We can create many to many relationship with two master detail relationship on junction object. Can we support many to many relationship with two mandatory lookup relationship (required checkbox is checked)? If yes, then what is the difference between m-n relationship created by master - details and lookup relationship?
@anilbathula@@anilbathula@
Hi san5aug,

 Yes you can create many to many relationship with two mandatory lookup relationships.
In master detail realtionship you cant change parent on child object and the parent field will be locked.
where as you create lookup and make it mandatory in these senario you can change the lookup(parent record) values.

Thanks
Anil.B