ADM-201 · Question #100
Which relationship can be selected in a custom report type where Accounts is the primary object and Contacts is the related object?
The correct answer is C. Each account may or may NOT have related contacts. In a custom report type with Accounts as the primary object and Contacts as the related object, the relationship chosen should reflect that each account may or may not have related contacts.
Question
Which relationship can be selected in a custom report type where Accounts is the primary object and Contacts is the related object?
Options
- AEach contact may or may NOT have a related account.
- BEach contact must have a related account.
- CEach account may or may NOT have related contacts.
- DEach account must NOT have related contacts.
How the community answered
(28 responses)- B4% (1)
- C89% (25)
- D7% (2)
Why each option
In a custom report type with Accounts as the primary object and Contacts as the related object, the relationship chosen should reflect that each account may or may not have related contacts.
This describes the relationship from the perspective of a Contact as the primary object to Account as the related object, not vice versa.
Contacts in Salesforce typically must have an Account, but this choice describes the relationship if Contact were the primary object.
In a custom report type, when Accounts are the primary object and Contacts are related, you can choose to show Accounts with or without Contacts. The option 'Each account may or may NOT have related contacts' (represented by 'A' records with or without 'B' records) accurately describes this 'outer join' type relationship, ensuring that all Accounts are included, even if they have no associated Contacts.
It is incorrect to state that an account must NOT have related contacts, as contacts are intrinsically linked to accounts in Salesforce's data model.
Concept tested: Custom Report Type relationships (A with or without B)
Source: https://help.salesforce.com/s/articleView?id=sf.custom_report_types_create.htm&type=5
Topics
Community Discussion
No community discussion yet for this question.