Solved

Turning on reference column?

  • 23 February 2021
  • 2 replies
  • 36 views

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

 

 

icon

Best answer by Mark Jongeling 23 February 2021, 12:20

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

2 replies

Userlevel 5
Badge +17

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! 

Reply