I have a data set that comprises 2 tables.
The first table is work orders, the second table is labour transactions. The relationship is one to many, linked by a WONUM key field.
I want to show the first labour transaction date for each work order in a straight table. Im trying to use the following function as one of the chart expressions:
But it is returning null in all cases except where there is only a single corresponding labour record (i.e where there is a one to one relationship).
Can anyone suggest another way to do this?