Hello,
I am seeking to group a report using a Field Lookup Table. The problem, is when I call the field in the header, "MarketLookup", the result is the ID associated with the field. For example, "2", instead of "Commercial".
Now, usually in VBA, I would use the expression: Me.MarketLookup.Column(1), which would return the column 1 instead of the ID.
Does anyone know how to apply these same principles to Reports?
Thanks,
I am seeking to group a report using a Field Lookup Table. The problem, is when I call the field in the header, "MarketLookup", the result is the ID associated with the field. For example, "2", instead of "Commercial".
Now, usually in VBA, I would use the expression: Me.MarketLookup.Column(1), which would return the column 1 instead of the ID.
Does anyone know how to apply these same principles to Reports?
Thanks,