Hi,

you have to create event action under ‘Execute online SQL’ and define the conditions for performing that action.

If you want to just showcase the Comment, then its better to put it as a read only field that will be more convinent and easy for you.

Hi , 

Thanks for replying 

I created some SQL commands but when I was trying in that Purchase requisition page , I got error like contact Administrator . 

What could be the issue there.

can u share the command code. seems somthing wrong in your code.

Unfortunately , The Environment I was working on got restarted yesterday ,The event got deleted .

But what possibly could be the commands .

I  remember giving the commands like  select Comments  Purchase requisition CFT and Insert into PO table .

SELECT CF$_COMMENT FROM PURCHASE_REQUISITION_CFT
INNER JOIN PURCHASE_ORDER_CFT
ON PURCHASE_REQUISITION_CFT.CF$_COMMENT= PURCHASE_ORDER_CFT.CF$_COMMENT;