Hi ,
Wondering if anyone can assist.
- I have a main table named CONSOLE
- I have a details table named TASKS
- They are associated by a foreign key column call "CONSOLE_ID".
In EVENTS\TASKS\EditPage\Process record values - I would like it to use the "Status" value in the CONSOLE table for the following if statement:
if(values["Status"]!= "Keep As Draft")
{
values["Request Deployer"]="";
values["Request Task Issue"]="";
values["Request Task Deployed"]="";
}
I know this statement would work if the "Status" column existed in the TASKS table, but the "Status" column exists in the CONSOLE table.
Any help would be greatly appreciated.