You could use a map to relate both lists, in fact it will be like one list with other lists inside.

A map takes a key, lets say Sales 1 and you can relate it to a list of items

Map<String, List<String>>{get; set;}

Where the first String is the key and the second the list of items.

Let me know if it helps you so i can guide thru on how to show the map on your visualforce page

That's a really good idea. Can it all be done within the same controller? Right now I have the one for the upper level items that just collects a list of them. The problem (if it's a problem) that I found when looking at the relationship is that the upper level items are not aware of lower level items. That is, the items know which sales order they belong to via lookup field but the sales orders don't know which items they have aside from the related list we see vissually. So I guess I'd also need a map<id, object> for each and then match the ids of the sales orders to the lookup field in the items.

Each SLC has a related list of Sales Order Item objects. Each Sales Order Item is aware of which SLC it belongs to through a lookup field called AddonSLC__c. What I'd like to see is a list of SLCs (given by the code above) and for each SLC, slightly indented, a list of Sales Order Items who point to that SLC in their  AddonSLC__c field.

If they are related you should just be able to use a single SOQL query to get what you want:

public class findSLCFamily { private final List<SLC__c> slcs; private final SLC__c currentSLC; public findSLCFamily() { slcs = [Select Id, (Select Name From License_Orders__r) from SLC__c]; } public List<SLC__c> getSLCFamily() { return slcs; } }

The child query is denoted by the normal brackets.  If you wanted to access these child records you just use slcs[0].License_Orders__r, which returns a list of License Order records related to slcs[0] record.  License_Orders__r is the name of the child relationship - you should be able to get this by clicking on the lookup field relating these objects under setup.

Hope that makes sense.

That's an idea. I'm a little fuzzy on how to put that into the component though. If I have the following in the controller:

slcs = [Select (Select Id, Product__c, Product_Family__c From Sales_Order_Items__r), Name, License_Order__c, Product__c, Devices__c, SUP_End_Date__c, Original_SLC__c from SLC__c where Original_SLC__c = :currentSLC.Original_SLC__c order by License_Order__c];