this is what I am trying to do but I confess I really have no idea. 

The TVS Code exists in the WO Purchase Req Lines and I want it to be visible on the Purchase Req Line Screen

Hi @lisa.gilesAB,

There are several ways to do so, but herewith an example with using a select statement.

It is only possible to have the filed as a read only field.

I have created custom field on the WO Part requisition line:

Then I create a Custom field on the PR line (read only):

With the following argument (v.requisition_no, v.RELEASE_NO, v.LINE_NO)

and select (SELECT RL.CF$_TEST FROM IFSAPP.PART_WO_REQUIS_PURCH_LINE_CFV RL
WHERE RL.REQUISITION_NO = :REQUISITION_NO
AND RL.LINE_NO = :LINE_NO
AND RL.RELEASE_NO = :RELEASE_NO)

This results that the field will show the custom field on the WO with the value which was entered there:

Is this what you were looking for?

PS: it should alos be possible the an expression instead of the select statement.

Good luck,

Robert 

Hi @EqeRobertK thank you so much for your reply.

I am now getting this:

What does it mean? 

@EqeRobertK This has now worked!! I think I left a bracket on the end of the statement when I copied. I have retyped and it now works!

thank you so so much