What is junction object and how to create it?

来源:互联网 发布:中文数据库 编辑:程序博客网 时间:2024/05/01 21:02
原文链接 

Salesforce supports 2 kinds of relationships like Master Detail and Lookup. They are both one-to-many relationship, and they are both  defined from the many-to-one side, that is from a child to a parent. They can be made one-to-one relationship by adding validation rules, or maybe triggers to enforce the one-to-one nature, i.e. only one child is allowed.

 

Junction objects are used to create many to many relationships between objects. If you take the Recruiting application example, you can see that a Position can be linked to many Candidates, and a Candidate can apply for different Positions. To create this data model you need a third object "Job Application" that links the 2.

 

So you'd create a lookup field for both Position and Candidate object on the "Job Application" object. This will establish many to many relationship between Position and Candidate via the "Job Application" object known as the junction object.

 

Fore more information, read this article http://wiki.developerforce.com/page/A_Deeper_look_at_SOQL_and_Relationship_Queries_on_Force.com.


      junction Object就是多对多中的中间表,在已经存在两个Master Obejct的情况下,创建Junction Object中间表,分别创建Master_detail关系到master Object上。而后设计Realted Label和Sharing Setting.

      另一方面在Master-Detail关系的数据结构中,处于Detail的Object是没有Owner字段的。


0 0
原创粉丝点击