+ Start a Discussion

is it possible to achieve M:M relationship without Junction object?


I have requirement where junction object required but i exceed object limitations
is it possible to achieve M:M relationship without junction object ? is there any potential drawback/impacts on data base architecture?

Requirement is :  One customer have multiple routes , one route have multiple customers 

Please let me know potential impacts if we are using jucntion object ?

Thanks Advance

RamuRamu (Salesforce Developers) 
It is not possible to create Master detail relationship between two objects linking to each other to establish many to many relationship. You would definately need a Junction object for this.

.Junction Object basically links two different objects and helps in accomplishing Many to Many relationship between two objects.

Hope this helps.