RR Table Link Question MOM
Posted: Thu Apr 05, 2007 3:30 pm
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?