I am trying to use "ExecuteSQL" function to obtain linked records (via foreign key). To do that I wish to use a variable in the "ExecuteSQL" function that will contain the id of the initial record.
See attached file as example: i have a table "Artist" and a table "Songs". I want to obtain only the songs for a certain Artist.
I am using SeedCode ExploreSQL to generate the code to obtain these songs. I am able to obtain all the songs present the database (see script/button "Get song 1") but not the songs linked to a certain Artist (see script/button "Get song 2")
Can someone help me ?
Thanks in advance.