Hi guys,
Appreciate if anyone of you can help me.
I'm a SSA ERP LN6.1 user.
How to use the Input/Ref. Expression for table field other than main table?
Description:
Using DFE to edit Form for cprrp1110s000, I inserted a field (tdsls400.orno) below existing field cprrp110.peor.
Why? Phase 1: To test whether the same Sales order number displayed by cprrp110.peor will also be displayed by the inserted tdsls400.orno.
If Phase 1 is ok, then Phase 2 is to have Customer Order field from tdsls400 to be displayed but should be index 4 (for Customer Order)
Alas but the Phase 1 is NOT OK.

Refer my attached file:-
Phase 1:
I inserted a field, tdsls400.orno in the middle picture .I key-in cprrp110.peor for the field name, tdsls400.orno in the right picture. In right diagram, why the REFERS_FROM did not displayed under Attributes? Is it that’s why it not working?
(note:Ctrl+Shift+7 to get the “Show XML tree”)

Phase 2 :
How to have Customer Order field from tdsls400 to be displayed but should be index 4 (for Customer Order)

Thanks in advance...
Regards,
Brad

The input/ref expression is not a reference field to another table. If the ref expression evaluates to true, you are allowed to input this field. If it is not of the main table, it will not be saved. (unless the program has added logic)

You need to have a field in the main table reference the order table for this to work properly. Place a 1 in the input/ref expression on the form. This will be a display only field.

Dear Toolswizard,
Thanks for your reply.

But why some can use the Inp/Ref on a form to draw data from another table and display in on the screen.
Refer (search keyword: Inp/Ref) to a thread dated 21 july 2004 by Mick Andrus on the title: Using Inp/Ref Expres to display fields from other table :-

" I have on two occasions, used the Inp/Ref function on a form to draw data from another table and display in on the screen. For instance, in the standard Baan production bill session, the component's description is not displayed. I've created references from the tibom010 table to the tcibd001 table to retrieve the component's item description from tcibd001 by declaring the reference in the Inp/Ref Expres setting. ......."

So, can the Inp/Ref be used to draw data from another table and display in on the screen? And How to do it?

Rgds
Brad

Did you see lisa's post in the thread (http://www.baanboard.com/baanboard/showthread.php?t=16047&highlight=Inp%2FRef+Expres+display+fields+table) you mentioned. It states that a reference has to be made to the primary index. Since I am not familiar with LN I am not sure that is the case.

Thanks for the reply, Mark.

How do those existing standard form able to have "REFERS_FROM .." appear under Attributes (refer to my earlier attached document)?
Is it automatic referenced or what do I put in the input/ref expression?
How do I learn to do it?

Sorry, but I can not help. I have no experience with LN. Hopefully Lisa or someother LN expert will pick up on this.

As far as I know, the input field/ref expression rules have not changed in LN. That is, the same as the 'refers to' clause rules. You can only build the reference chain if there are references defined in Maintain Table Definitions / Field References.

Hi Brad,

Are you able to get the field from other table? Any solution for that?

See the other post I made. Regards Adriaan