Solved

SHow fields from related tables

  • 3 January 2022
  • 4 replies
  • 62 views

Userlevel 1
Badge

Hi, i have a relationship between a technician and a incident. the technician is a separate table with a relation to the incident table. currently i am unable to select fields from related tables. how can i select these fields?

icon

Best answer by Erwin Ekkel 4 January 2022, 11:18

View original

4 replies

Userlevel 6
Badge +16

Can you explain the end goal? There are several ways to achieve this depending on what you want to achieve the answer can differ. 

Userlevel 1
Badge

so i have this chart. in which i show the amount of incidents per technician. i want to show the name of the technician instead of the technician id in the legend.

Userlevel 6
Badge +16

You can set a default lookup in the subject of the source table. This will be shown instead of the idea by default:
 


If you want to set a different lookup value for a certain table/reference change the reference lookup column in the subject of the target table: 
 

 

Userlevel 6
Badge +16

Did my last reply solve your problem/answer your question?

Reply