Forum Discussion
Display data value from a non-active relation
Hello, I have 2 tables joined by a non-active relation: I would like to display some fields from tbl_workOrders and the IncidentNumber field from tbl_incidents but I can't do that manuall...
Hi,
Why is the relationship not an active one? If i does need to remain inactive, then you will have to write a measure with the USERELATIONSHIP() function.
Indeed, I have another relation active with the calendar table. Userelationship function must be used with the calculate function but I just need to display the incidentNumber related to the workorderid.