I have a report that has multiple tables joined together. One of the tables is a child table that can contain multiple lines to the one line parent table. I want to continue to keep one line on the report but concatenate one field from the child table.

I was trying to do this with a formula field with something like this:
Trim(tableC.feild1) + ‘ ‘ + trim(tableC.field1)

TableC = Child table

Any ideas?

Thanks,
James




Edited by Jmac - 24 Jun 2011 at 5:59am