Can we create Junction object with one master-detail and one lookup field

lookupmaster-detailrelationships

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?

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.

  • Allows users with at least Read access to the Master record to create, edit, or delete related Detail records.
  • Allows users with at least Read/Write access to the Master record to create, edit, or delete related Detail records.

Remember you cant create a child record without linking master object record

Related Topic