OK, I understand how to join to tables within one dataset to display master/detail in a data grid. With the master in one row then detail records under it. But what I would like to do is display them both in one row. For example list of children with the parent name in the same row. The parent name maybe repeated in each row if they have more then one child. Or another example list of child with their race displayed in the same row. The child table has a race ID to link to the Race table. I know I could do this in a SQL join but where’s the fun in that. Plus in the project I’m working on I can’t do it that way. Any help would be great.

Join two tables