As you have found, the List function can only operate on a single field. So what you will need to do is to concatenate the data you want in the IRG Invest Amounts table, and then use the List function to grab that data for each related record.
So you may have a calculation field in the IRG Invest Amounts table called date_amount_project that is:
INVEST_DT & " " & IRG Invest Amounts::INVAMT & " " & IRG LLC::LLC_DESC
And then your calculation becomes:
"¶¶" & "Invest Date Invest Amount Project " & "¶" & List( IRG Invest Amounts::date_amount_project)
Does that make sense?
Thanks for the help. Worked exactly as you said. Now am looking for help
with formatting the invest amt with 2 decimal places, dollar sign, and thousand
separators. Will see if I can find in the forum.