SHow fields from related tables

  • 3 January 2022
  • 3 replies

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?

3 replies

Userlevel 5
Badge +9

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

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 5
Badge +9

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: