Skip to main content
Solved

Turning on reference column?

  • February 23, 2021
  • 2 replies
  • 61 views

Is it possible to turn on reference column “Transport ID”?

 

 

Best answer by Mark Jongeling

Hi, 

Since you've opened this subject via a reference, the column is not shown. It is also not possible to show the column in this way in the List. 

To make it visible in the list (and form), have an expression field that has the value of transport_id :

t1.transport_id

Lay a reference on this expression field too and make sure the detail will be shown via this reference instead of via the reference on the transport_id column. 

Diagram
Application

Above you see that test_id, the PK column, is now visible in the list, but not the reference column test_id_expression. In the form you do see all columns but you wish to see it in the list, hence my example.

View original
Did this topic help you find an answer to your question?
This topic has been closed for comments

Mark Jongeling
Administrator
Forum|alt.badge.img+23

Hi, 

Since you've opened this subject via a reference, the column is not shown. It is also not possible to show the column in this way in the List. 

To make it visible in the list (and form), have an expression field that has the value of transport_id :

t1.transport_id

Lay a reference on this expression field too and make sure the detail will be shown via this reference instead of via the reference on the transport_id column. 

Diagram
Application

Above you see that test_id, the PK column, is now visible in the list, but not the reference column test_id_expression. In the form you do see all columns but you wish to see it in the list, hence my example.


@Mark Jongeling That's what i wanted. Thank you! 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings