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?
Solved
SHow fields from related tables
- Apprentice
Best answer by Erwin Ekkel
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:
This topic has been closed for replies.
Can you explain the end goal? There are several ways to achieve this depending on what you want to achieve the answer can differ.
- Apprentice
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.
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:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.