script with variables and lookups..
OK Friends. I need your help again..
I have multiple variables but this is just one of them.. I am looking to see if the temp is less than 80 and work load is a number. Based on this info I would like to insert text from another table that is already build and has a relationship.
So the results I am looking for would be:
find JSA_Heat_Stress::Work_Load=1 and insert the text from JSA_Heat_Stress::Work_Break
when work_load=2 then find JSA_Heat_Stress::Work_Load=2 and insert the text from JSA_Heat_Stress::Work_Break
and so on..
Here is what I have so far..
Case ( Temp <=80 and Work_Load=1; xxx;
Temp <=80 and Work_Load=2;xxxx;
Temp <=80 and Work_Load=3;xxxx;
Temp <=80 and Work_Load=4;xx;
"Please Update Temp and Work Load" )