Value List From request SQL

Discussion created by informatique.atoutdelice on May 30, 2016
Latest reply on May 31, 2016 by informatique.atoutdelice

Hi all,



I'm a new on FileMaker Pro advanced 14 and i wanna know how to make a dynamic List from a request SQL, i have tow categorie CAT01, CAT02 and Product link with one categorie, for example : PROD01 have CAT01, i try to get a dynamic list of PROD01 that i can use in a calculate field.


My request SQL is " select name from product where categorie = CAT01 " but the probleme is that it's not display in a List, all the product are in one field of my List.


thanks for help, my english is a little bit poor, so tell me if you don't understand my problem.



Have a good day.