This is a bit difficult to explain but the attached work book with example I hope helps.
I want to transform records, but I want to refer to a Table Column,
So manually, which I have included is ;
So the problem is the Record.Field( ToTable{0} etc. which I want to access in a more dynamic way;
So I can create the first part ;
So is there any way I can add the last part of each [Unit] to the above replacement, The attached query 'result' and 'Manual'
give an illustration of what I was trying for.
Richard.
Bookmarks