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?
Page 1 / 1
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.
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:
Did my last reply solve your problem/answer your question?
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.