Can we create Junction object with one master-detail and one lookup field? What will be its security configuration in case Lookup relationship field is created first?
Can we create Junction object with one master-detail and one lookup field
lookupmaster-detailrelationships
Best Answer
Answer to your first questions is "Yes" you can have a junction object by using one parent as M-D and another as Lookup.
For second question sharing setting of your child object would be Controlled by parent and it can't be changed to anything else.
Depending on your use case you can expand or restrict sharing setting on child object from "Sharing Setting" option at master detail relationship field.
Remember you cant create a child record without linking master object record