after following the Manage Relational table tutorial, the WADAitems recordset on my details page looks like this:
SELECT ItemID, `itemcategory`.`ItemCatName` AS itemcategory_ItemCatName, ItemName, ItemShortDesc, ItemLongDesc, ItemPrice, ItemSKU, ItemThumb, ItemImage, ItemWeight
FROM items LEFT JOIN itemcategory ON itemcategory.ItemCatID = items.ItemCatID
WHERE ItemID = ParamItemID
This is returning details from the items table, and the related category name from the itemcategory table. the ParamItemID variable used in the where clause is the ItemID URl variable that is used to tell the details page which item to display.
to return the related genres, you would need to edit the recordset to include the genres.GenreName column in the select statement, and include left joins for the itemgenres and genres tables:
SELECT ItemID, `itemcategory`.`ItemCatName` AS itemcategory_ItemCatName, ItemName, ItemShortDesc, ItemLongDesc, ItemPrice, ItemSKU, ItemThumb, ItemImage, ItemWeight, genres.GenreName
FROM items
LEFT JOIN itemcategory ON itemcategory.ItemCatID = items.ItemCatID
LEFT JOIN itemgenres ON itemgenres.ItemGenreItemID = items.ItemID
LEFT JOIN genres ON itemgenres.ItemGenreGenreID = genres.GenreID
WHERE ItemID = ParamItemID
Then add the genres.GenreName binding to the page and add a repeat region around it.
Doing this on the results page would be more problematic, you would need to use a nested recordset to do this on the results page.