I need to create a list view in SharePoint where several foreign Items which are referencing the the actual item are beeing displayed.
As example the actual list is called companies and for each company several or all employees should be displayed.
I've created a custom view in SharePoint Designer 2010 using the "Preview Pane" as design which already comes quit close to my preferred layout.
But how can I add the items (employees), which are referencing the company? I've looked into the source of the page and saw a lot of xml and xlst which gave me somehow the idea of doing this. However I would like to have some best practices on querying referencing items. Do I need to somehow join the lists?
Including the html for displaying seems like an easy go, but I don't now how to get the data to display! Thanks for any information :)