AnsweredAssumed Answered

How to get the 2 dimension dataset

Question asked by windtech on Apr 19, 2018
Latest reply on Apr 22, 2018 by windtech

Hi There

 

I have some tables as blow,

 

 

Material (Material id, material name)

Material idmaterial name
1tomato
2potato
3orrange

 

 

Taste (Taste id, Taste name)

Taste idtaste name
1good
2bad
3good+

 

 

Recipe (id, recipe name)

Recipe idrecipe name
1recipe1
2recipe2
3recipe3

 

 

Recipe Material Details (id, recipe_id, material name)

idrecipe_idmaterial name
11tomato
21potato
32tomato
42orrange

 

 

Recipe Taste Details (id, recipe_id, taste name)

idrecipe_idtaste name
11good
21bad
32good+

 

we have unlimited materials, taste and different recipes. when I use the keyword of "tomato" to find the data from FM. I want to list all recipes info with "tomato" keyword and show the data in the layout as blow

recipe1recipe2
tomato5g5g
potato4g
orrange7g

 

Can anyone advise how to get those 2 dimension data using Filemaker. thanks

Outcomes