My general idea is following:
User have on the sheet 2 Table Box
1st - with parameters (ObjectID = "tblParam")
2nd - result set (ObjectID = "tblResult")
When user select (click) any row in "tblParam"
initialize the variables (vParam1, vParam2, vParam3) and reload SQL-query related with "tblResult".
Edit script has following code:
sqlTblParam:
SQL SELECT 1 as Param1, 120 as Param2, 0.51 as Param3
UNION
SELECT 1 as Param1, 120 as Param2, 0.52 as Param3
UNION
SELECT 2 as Param1, 120 as Param2, 0.5 as Param3
UNION
SELECT 3 as Param1, 120 as Param2, 0.5 as Param3;
sqlTblResult:
SQL SELECT * FROM tblData WHERE Param1 = $(vParam1) and Param2 = $(vParam2) and Param3 = $(vParam3);
I see this implementation so:
Step 1 - after user choice I need initialisation the variables (vParam1, vParam2, vParam3)
Step 2 - Reload sqlTblResult
Please give me hint how can I do this idea?
