I have 3 tables, products, ingredients, and products_ingredients.

I have set up an entitydatasource to products_ingredients, filtered with a where condition for product_id, and using the include=ìngredients to also get related data. My join table has product_id and ingredient_id set with foreign keys.

What I need is to show the ingredients.name in my ext.gridview and not just the id columns.

How do I access, or bind the values from ingredients to my lookup on products_ingredients, and show this in the gridview? I have read that if I use the asp.net grid, I can make a template column and obtain the ingredient name by using ingredients.name, but that doesn't seem to work if I place ingredients.name in my store.

Can anyone point me in the right direction? There doesn't seem to be many requests here for help with entitydatasource.