I've done this before, where I add two grids (by dragging two tables onto the form from my data source), and they have a relation on them so basically what you select in the top grid 're-populates' contents in the bottom grid.

This is all fine and dandy, and makes sense, because that relation existed in the data source (the child table was inside the parent table, meaning you drag the parent table, click into it and you see its fields and another table, which you can click into to see its fields).

How can I set this up with two views? Is it even possible?
I tried adding a relation on the data set in design time, but that did not allow me to get the two views to act like two tables with a relation.