You need to sign in to do that
Don't have an account?
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 |... |... |
--------------------------------------------------------------------------------------------------------
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