Hi,
I'm trying to extract the notes from the Sales Header table (specifically Sales Returns). I know how to do this and I think what I've done is correct but when the report is run it only returns the note for the first record in the NL(Row).
Here is the basic query I have written (design more and the formulae themselves)
And here's the outcome when running the query
I have checked in BC that these SROs do have notes and aren't blank
I've also checked doing NL("first","Record Link" and NL("last","Record Link" to see if that makes any difference
My guess is it's something to do with the Jet setup. So I've tried it on multiple different machines, all with the same result.
Any help would be very welcome
