5 Replies Latest reply on May 31, 2016 2:34 AM by informatique.atoutdelice

    Value List From request SQL


      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.