Multiple tables

[abthomas]

Hello,

I want to display (in a gridview) data from multiple tables. The first table has names, the second address lines.

Name:
NID Name
1 John
2 Julie

AddressLines:
NID Line Text
1 1 29 Fairfield road
2 1 The cottages
2 2 Ring road

I would love (please) a display like this:
---------------------------------------
| John 29 Fairfield road
---------------------------------------
| Julie The cottages
| Ring road
---------------------------------------

I can configure a datasource to generate this:
| John 29 Fairfield road
---------------------------------------
| Julie The cottages
---------------------------------------
| Julie Ring road

And I've managed to get a gridview inside a gridview using two datasources (but don't know how to feed the Name.NID into AddressLines.NID.

Is this the right way to do it (ie the best way), if so - how do I feed in Name.NID into the Address datasource?

Thanks.