I need to create a report that pulls data from multiple tables. One of the fields required in the report is Requester L1 Code, which represents the employee number of the department head.
The Department Head is stored in the Department table, and the employee number for that department head is stored in the User table. Is it possible to retrieve the department head’s employee number using dot‑walking or something?
.png){kind=link}
