Hi Thomas!

If you have created a relation between for instance the Products table and
the Products2Genre tables and that in time to the Genre table then you can
just walk down the hierarchy.

//This will symbolize the fetching of the products
ProductDataSet ds = GetTheProducts();

string categoryName =
ds.Products[x].GetProduct2GenreRows()[y].GetGenreRows()[z].genrename

So in your case you could do it this way

foreach (ProductDataSet.Product2Genre productGen in
ds.Procducts[5].GetProduct2GenreRows())
{
   foreach (ProductDataSet.Genre gen in productGen.GetGenreRows())
   {
       //Do what you want to do with the genre here
   }
}

Well, I hope this helps you out a bit in the right direction

//Mikael