Hi all

I am using LN 6.1
I would like to show fields from linked table - tiipd001 on a multioccurence grid where the the main table is tcibd001.

I thought I read somewhere that I could do this in the Input/Ref expression of the field in DFE of the session.
Please help

Thanks and regards

If The field has reference to other table, you can do this by double clicking on the field in DFE -> Add Fields windows..

It will show up all fields of the referenced table.

Hi,

Could someone explain to use Input/Ref expression in DFE with some examples.

Thanks for your support.
Regards,
Sivasankari

Hi,

If the field Input/Ref expression has value as 0 then its non-editable and a display field. You can maintain conditions on when to make it input/display field.

Regards,
Amit

Hi Amit,

Thanks for your reply. I would like to use this field for reading data from a specific referenced field or reference path.

For example in DFE editor for field tfacr200.dim2 I would want to set an expression such that it gets its value from tfgld102.dim2.

From online help I understand that the Input/Ref Expression is the place where I set it to happen.

Could you please let me know the expression to be used.

Regards,
Sivasankari

Dear all,

Any inputs on the requested information.

I am looking for some customization at the field level without the source code and I guess this Input/Ref expression will pave a way for it.

Awaiting your valuable inputs/suggestions.
Regards,
Sivasankari

Hi,

This is what I got from the DFE Help:

Input Condition/Reference Expression:
Specifies the input condition or reference expression of the form field.
Input condition: The input condition determines the condition for which input on the input field is allowed. For example, If the price > 0, the input is only allowed if the value of the variable price is greater than 0.

Reference expression: The reference field or reference path can be used if a table field from a table other than the main table is used. This can be used if the main table refers twice to a reference table.

Examples:

tdsls000.item1 (reference field)
tdsls000.item2, tiitm001.item (reference path)


By looking at this, I think we can only enable/disable field based on the Input Condition/Reference Expression.

In your case Mr.Sivasankari, I don't think we will be able to default value in tfacr200.dim2 from tfgld102.dim2

Regards,
Amit

Thanks for your inputs Amit.

Regards,
Sivasankari