Populate a field of a custom table from a reference table

[chatsaurav19]

Hi All,

I have a reference table 'x' ( shown below ) . The 'Display' is 'true' for column 'Label'.

I have created my own custom field 'y'  (which is referring table 'x' ). I wish to get the data from the 'Value' field in table 'x' and populate in field 'y' but since 'Label' is set to true it is returning me 'Label' values.

As a solution I was trying to get this achieved from the 'Attributes' of 'y' field like:::

ref_auto_completer=AJAXTableCompleter,ref_ac_columns=u_value,ref_ac_columns_search=true

But this is not working! Is there a way from where I can fetch the data from 'Value' field? 

Thanks and Regards,

Saurabh Chatterjee

[omkar_jadhav_]

Hi @chatsaurav19 
Here are the steps that might help you,
1 - open form layout that shows your custom reference field 'y'
2 - right click on that field and click on configure dictionary
3 - go to the reference specification and select the condition 'value is anything / non empty' (make sure the value field in table 'x' has display value true)
4 - save the changes

This will show you the values from reference table

[chatsaurav19]

Hi @omkar_jadhav_  Unfortunately I cannot make 'value' field as 'true' since the table 'x' is used by other projects as well.

[omkar_jadhav_]

That's okay, just give reference condition as value field is not empty,
Then 'y' field will show you the values form table 'x'
as given below

reference - your table 'x'
and in condition select field 'value' (I've mentioned my demo field)

[chatsaurav19]

Hi @omkar_jadhav_ Nope it didn't work!