You need to sign in to do that
Don't have an account?
Visualforce: Displaying A Custom Object's Related List When the Custom Object Is Not Directly "Related"
Hello,
I've been tasked with creating an executive page layout where the basic information is displayed within a standard page layout and if they'd like to see more details they can click a link and see that. That translates into a Visualforce page. I've gotten as far as creating the page, but where I'm stumped is displaying the multiple custom object related lists. When I added them at first, I started to get the " '<object> is not a valid child relationship name for entity Account' " error. After looking at this, I realised that several of the custom objects are related to the Account by way of other standard objects. An example of this is my Account Connections object. It has a Master-Detail relationship to the Contact object and can be viewed on the standard Account detail page. How would I go about adding this custom object's related list into my VF code? This is what I have thus far:
I'm somewhat under a time crunch, so any help you the community can provide me is greatly appreciated! Thank you so much.
Diavonna
I've been tasked with creating an executive page layout where the basic information is displayed within a standard page layout and if they'd like to see more details they can click a link and see that. That translates into a Visualforce page. I've gotten as far as creating the page, but where I'm stumped is displaying the multiple custom object related lists. When I added them at first, I started to get the " '<object> is not a valid child relationship name for entity Account' " error. After looking at this, I realised that several of the custom objects are related to the Account by way of other standard objects. An example of this is my Account Connections object. It has a Master-Detail relationship to the Contact object and can be viewed on the standard Account detail page. How would I go about adding this custom object's related list into my VF code? This is what I have thus far:
<apex:page standardController="account"> <apex:sectionHeader title="Account" subtitle="{!account.FirstName}"/> <apex:pageBlock title="Account"> <apex:pageBlockSection title="Account Information" columns="2"> <apex:outputField title="Primary Relationship Manager" value="{!account.Primary_Relationship_Manager__c}"/> <apex:outputField title="Account Owner" value="{!account.OwnerId}"/> <apex:outputField title="Tax Exempt" value="{!account.Tax_Exempt__c}"/> <apex:outputField title="Account Record Type" value="{!account.RecordTypeId}"/> <apex:outputField title="EIN" value="{!account.EIN_Number__c}"/> <apex:outputField title="Account Name" value="{!account.Name}"/> <apex:outputField title="Type" value="{!account.Type}"/> <apex:outputField title="Parent Account" value="{!account.ParentId}"/> <apex:outputField title="Tocqueville City" value="{!account.Tocqueville_City__c}"/> <apex:outputField title="Preferred Name" value="{!account.Preferred_Name__c}"/> </apex:pageBlockSection> <apex:pageBlockSection title="Description Information" columns="1"> <apex:outputField title="Description" value="{!account.Description}"/> <apex:outputField title="Best Work Desc - 2014 CIPS" value="{!account.Best_Work_Desc_2014_CIPS__c}"/> </apex:pageBlockSection> <apex:pageBlockSection title="Address & Contact Information" columns="2"> <apex:outputField title="Phone" value="{!account.Phone}"/> <apex:outputField title="Secondary Phone" value="{!account.Secondary_Phone__c}"/> <apex:outputField title="Email" value="{!account.Email__c}"/> <apex:outputField title="Toll Free" value="{!account.TollFree__c}"/> <apex:outputField title="Secondary Email" value="{!account.Secondary_Email__c}"/> <apex:outputField title="Fax" value="{!account.Fax}"/> <apex:outputField title="Email Recipient" value="{!account.Email_Recipient__c}"/> <apex:outputField title="Call Before Fax" value="{!account.Call_Before_Fax__c}"/> <apex:outputField title="Website" value="{!account.Website}"/> <apex:outputField title="Pledge URL" value="{!account.Pledge_URL__c}"/> </apex:pageBlockSection> <apex:pageBlockSection title="Additional Address Information" columns="2"> <apex:outputField title="Other Street" value="{!account.Other_Street__c}"/> <apex:outputField title="Other City" value="{!account.Other_City__c}"/> <apex:outputField title="Other State/Province" value="{!account.Other_State_Province__c}"/> <apex:outputField title="Other Zip/Postal Code" value="{!account.Other_Zip_Postal_Code__c}"/> <apex:outputField title="Other Country" value="{!account.Other_Country__c}"/> </apex:pageBlockSection> <apex:pageBlockSection title="Membership Information" columns="2"> <apex:outputField title="Membership Status" value="{!account.UWA_Membership_Status__c}"/> <apex:outputField title="Segment" value="{!account.Segment__c}"/> <apex:outputField title="UW Org Number" value="{!account.UWOrgNumber__c}"/> <apex:outputField title="UW Metro Size" value="{!account.UW_Metro_Size__c}"/> <apex:outputField title="UW Org Number (old)" value="{!account.UW_Org_Number_old__c}"/> <apex:outputField title="UW Metro Alpha Code" value="{!account.Metro_Alpha_Code__c}"/> <apex:outputField title="Opportunity 150" value="{!account.Critical_150__c}"/> <apex:outputField title="Relationship Management Tier" value="{!account.Top_Strategic_Field_Relations__c}"/> <apex:outputField title="Major Market" value="{!account.Major_Market__c}"/> <apex:outputField title="RD Top Market" value="{!account.RD_Top_Market__c}"/> </apex:pageBlockSection> <apex:pageBlockSection title="Social Media" columns="2"> <apex:outputField title="YouTube URL" value="{!account.YouTube_URL__c}"/> <apex:outputField title="Twitter" value="{!account.Twitter__c}"/> <apex:outputField title="Vimeo URL" value="{!account.Vimeo_URL__c}"/> <apex:outputField title="Facebook Page" value="{!account.Facebook_Page__c}"/> <apex:outputField title="Vine URL" value="{!account.Vine_URL__c}"/> <apex:outputField title="Facebook Page Name" value="{!account.Facebook_Page_Name__c}"/> <apex:outputField title="Other Video Sharing URL" value="{!account.Other_Video_Sharing_URL__c}"/> <apex:outputField title="Tumblr URL" value="{!account.Tumblr_URL__c}"/> <apex:outputField title="Flickr URL" value="{!account.Flickr_URL__c}"/> <apex:outputField title="Pinterest URL" value="{!account.Pinterest_URL__c}"/> <apex:outputField title="Picasa Albums URL" value="{!account.Picasa_Albums_URL__c}"/> <apex:outputField title="LinkedIn URL" value="{!account.LinkedIn_URL__c}"/> <apex:outputField title="Instagram URL" value="{!account.Instagram_URL__c}"/> <apex:outputField title="Google+ URL" value="{!account.Google_URL__c}"/> <apex:outputField title="Other Photo Sharing URL" value="{!account.Other_Photo_Sharing_URL__c}"/> <apex:outputField title="Blog URL" value="{!account.Blog_URL__c}"/> <apex:outputField title="Social Media Council (SMC)" value="{!account.Social_Media_Council__c}"/> <apex:outputField title="SMC Start Date" value="{!account.SMC_Start_Date__c}"/> <apex:outputField title="SMC End Date" value="{!account.SMC_End_Date__c}"/> </apex:pageBlockSection> <apex:pageBlockSection title="Campaign for the Common Good" columns="1"> <apex:outputField title="CCG Participant" value="{!account.CCG_Participant__c}"/> <apex:outputField title="One Million Online Engagement Agreement" value="{!account.CCG_Terms_Conditions_Agreement__c}"/> <apex:outputField title="Company Affinity Groups" value="{!account.program_involvement__c}"/> </apex:pageBlockSection> <apex:pageBlockSection title="Volunteerism" columns="1"> <apex:outputField title="Volunteer Management Platform" value="{!account.Volunteer_Matching_Application__c}"/> </apex:pageBlockSection> <apex:pageBlockSection title="Education Involvement" columns="2"> <apex:outputField title="Education Focus Areas" value="{!account.Education_Focus_Areas__c}"/> <apex:outputField title="Other Education Focus Areas" value="{!account.Other_Education_Focus_Areas__c}"/> <apex:outputField title="Mobilization Dimensions" value="{!account.Mobilization_Dimensions__c}"/> </apex:pageBlockSection> <apex:pageBlockSection title="System Information" columns="2"> <apex:outputField title="Account Division" value="{!account.Division}"/> <apex:outputField title="name ID" value="{!account.IMIS_name_ID__c}"/> <apex:outputField title="SalesforceId" value="{!account.SalesforceId__c}"/> <apex:outputField title="UWO Id" value="{!account.uwoId__c}"/> </apex:pageBlockSection> <apex:relatedList list="Contacts"/> <apex:relatedList list="Account Connection"/> <apex:relatedList list="OpenActivities"/> <apex:relatedList list="ActivityHistories"/> <apex:relatedList list="Cases"/> <apex:relatedList list="CombinedAttachments"/> </apex:pageBlock> </apex:page>
I'm somewhat under a time crunch, so any help you the community can provide me is greatly appreciated! Thank you so much.
Diavonna
I replied this question on stack exchange. let me know if that help you.
Thank you so much for the response, Himanshu! It really helped.