RR Table Link Question MOM

[seg0906]

I use RW to pull data from the MOM system. There are 2 tables I would like to link - Invoice.dbf and Items.dbf, however there is no unique field to link by. In order to link I would need to create a new field concatenating the Order Number||Invoice Part in the Invoice Table - and link that to a concatenated Order Number||Invoice Part in the Items Table. Is there anyway to do this kind of thing using report writer?

[ed_tuton]

Use the CMS.dbf as the linking file