function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
splitsplit 

Table with related records. [HELP]

I have:

Controller:
...
List<X__c> = [SELECT Id, (SELECT Id, Y_value1__c, Y_value2__c FROM Y__r) FROM X__c];
...


Page:
...
<apex:pageBlockTable value="{!X__c}" var="x">
	<apex:column value="{!x.Id}"/>
	<apex:column>
		<apex:pageBlockTable value="{!X__c.Y__r}" var="y">
			<apex:column value="{!y.Id}">
			<apex:column value="{!y.Y_value1__c}">
			<apex:column value="{!y.Y_value2__c}">
			</apex:pageBlockTable>
		</apex:column>
	</apex:pageBlockTable>
...

-----------------------------------------------
x.Id1	|y.Id1	|y.Y_value1__c	|y.Y_value2__c	|
	|y.Id2	|y.Y_value1__c	|y.Y_value2__c	|
-----------------------------------------------
x.Id2	|y.Id1	|y.Y_value1__c	|y.Y_value2__c	|
	|y.Id2	|y.Y_value1__c	|y.Y_value2__c	|
	|y.Idn	|y.Y_value1__c	|y.Y_value2__c	|
-----------------------------------------------
x.Idn	|	|y.Y_value1__c	|y.Y_value2__c	|
...	|...	|...		|...		|




How do this???? ->
------------------------------------------------------------------------
x.Id1	|		y.Id1		|		y.Id2		|
	----------------------------------------------------------------
	|y.Y_value1__c	|y.Y_value2__c	|y.Y_value1__c	|y.Y_value2__c	|
--------------------------------------------------------------------------------------------------------
x.Id2	|		y.Id1		|		y.Id2		|		y.Idn		|
	------------------------------------------------------------------------------------------------
	|y.Y_value1__c	|y.Y_value2__c	|y.Y_value1__c	|y.Y_value2__c	|y.Y_value1__c	|y.Y_value2__c	|
--------------------------------------------------------------------------------------------------------
x.Idn	|		y.Id1		|		y.Idn		|		...		|
	------------------------------------------------------------------------------------------------
	|y.Y_value1__c	|y.Y_value2__c	|y.Y_value1__c	|y.Y_value2__c	|...		|...		|
--------------------------------------------------------------------------------------------------------
 


Best Answer chosen by Admin (Salesforce Developers) 
Jeremy.NottinghJeremy.Nottingh
 Does this do something like what you're looking for? 
 

<apex:repeat value="{!X__c}" var="x">
 <table><tr><td>{!x.Id}</td>
  <apex:repeat value="{!x.Y__r}" var="y">
   <td>
    <table>
     <tr><td colspan="2" >{!y.Id}</td></tr>
     <tr><td>{!y.Y_value1__c}</td><td>{!y.Y_value2__c}</td></tr>
    </table>
   </td>
  </apex:repeat>
  </tr>
 </table>
</apex:repeat>
 
Jeremy