This seems like it should be simple, but perhaps the inherent simplicity of
SharePoint Designer makes it a bit more complex.
I have two lists that I want to link and display in a relational
(parent/child) format. I thought first that maybe I could just create a
Linked Source and it would somehow join the two lists for me, but there
seems to be no way to assign a join field (in which case it's not really a
join at all, so I don't see the point). All I get is List 1 on one side and
List 2 on the other side, which again makes no sense from a "join" point of
view.
I've fiddled with the XSLT but there doesn't seem to be a way to do this.
Does anyone have a suggestion as to how to get the data to nest, or at least
to be truly joined? I read Boris Gomiunik's post on nested data, but he
seems to be dealing with a single list that he wants to display in a "group
by" fashion.