Setting Activity text field with recordset

Kate Olszewska

Hi,

I am trying to set activity text field in the Notes tab with the multiple results from SQL query however I get only top result in my case 1 DocNum but I have more than one DocNum

The code I use set ($[$25.0.0]|SQL:SELECT T0."DocNum",T0."DocDate" FROM ODLN T0 WHERE T0."U_ConComInv" ='Y' and T0."CANCELED" ='N' and ifnull(T0."U_ConComInvComplete",' ') <>'Y' and T0."CardCode"=$[$9.0.0]);

I tried create activity UF and also I get one result from my query.

Is there any way to do it?

Thank you

Kate 

 

Comments

0 comments

Please sign in to leave a comment.