Ok, I am migrating an biding database from 5.5.

In the old version I have a calc field the references discription fields in the same table and gives me a paragraph that is printed with the dollar amount for that"Area".

In the new version, I have made a join table that holds all the line items making it much more flexable, however, how do you summerize text fields from a related table and show them in a paragraph?

Does anyone know how this could be accomplished?

I see the new function:

GetNthRecord ( fieldName ; recordNumber )

Perhaps this could be used in some fashion in combination with recursion to arrive at a result?

Custom Function: Concatenate

Parameters: field, start, number

Calc:

Case(start < number; getNthRecord(field; start)&" "&concatenate(field; start + 1; number);

start = number; getNthRecord(field; start)

)

This seems to be a duplicate of this thread:

http://filemakertoday.com/filemakertoday.com_non_ssl/com/showthread.php?t=9952