DataGrid question

[Guest]

If I have two tables i.e. Authors and Titles from Pubs, and I want to display
the Authors name and then all titles by a particular author in a DataGrid,
how would I do that?

Is there a way to display parent/child relationships in the same datagrid?

eg. Author 1
Title 1
Title 2

Author 2
Some title

Author 3
Some title

Author 4
Some title 1
Some title 2
Some title 3

 

[Guest]

Hi Sandy
try to make a view and put ur relation and load ur data from this view
Hope this help