Long story short, I have to export data from a related table into a field I can then merge into a word document.

Table B - Child Table

I concatenate a number of fields together to form one field "display"

Table A - Main Table

I create a value list of all related items in Table B. In a field I then have

Substitute(ValueListItems (Get ( FileName ) ; "DisbursementDescription" ); "¶"; "%|%")

This works great.

EXCEPT

It will de-duplicate which I don't want. It has to include ALL related values irrespective of if the concatenanted data appears more than once in Table B.

(as an example of the sort of data being concatenanted..

12/10/2009 - Title Search - $25

12/10/2009 - Title Search - $25

I understand I could include the serialID as part of the concatenation and it would work fine, however the data must be as required without any further information (i.e serial ID).

Any ideas of a work around?

TIA

How about using the List ( ) function instead of ValueListItems?

Doh. Thanks so much :0)

Can't see the hills for the trees sometimes ...