Unique dishes with a several diets assigned

[frankikoch]

I have a table that has different names of dishes that are assigned to different diets, many times a single name of the dish has several diets. How can I get a list of dishes with the unique name and their related diets.

The fist table is a child table of the another table wich is a parent table.

[frankikoch]

For example I want to group the dish "Macarrones en blanco con
calabacin" to list the four diets asociated:

"PROTECCIÓN GÁSTRICA"

"ASTRINGENTE"

"INSUFICIENCIA RENAL (NO HUEVO)"

"DIÁLISIS (NO HUEVO)"

[frankikoch]

I have also this table

Thank you so much for the collaboration

[Joseph_Seddik]

You should have two separate tables:

1. Diets table, listing the different diets each in its own row.
2. Dishes table, with an EnumList column with base type Ref pointing towards the Dietes table.

In this case using a simple dereference expression like: [dishID].[dietList], you'll be able to retrieve the diets related to each dish.