On 8/26/08 1:15 PM, "BARBARA PASSMAN" <[EMAIL PROTECTED]> wrote in whole
or in part:
> thank you
> I am exporting from Mr. Jones' record,not from the related rcords.
> Your last point; making the repeated field one calculation IS something I
> thought about but don't know now to do.
> IF you or someone can point me the right way , that will solve most of the
> problem
>
> The other problem , my first, is that although I am trying to export Mr.
> Jones' record (its actually a sports team record, listing the Team, Mr Jones
> and his assitant.
> This is the core data. Data is a direct import from an Excel spreadsheet.
> The portal, related data are the training credentials for Mr, Jones and his
> assistant.
> That exports! but only one the first item. So I have to try the calculated
> field...and that sounds like it could be complicated but worth learning how to
> do.
>
> Thank you so much
> Barbara P
How many repeats? For example with 6 repeats:
newField_c = oldField[1] & "\r" & oldField[2] & "\r" & oldField[3] &
"\r" & oldField[4] & "\r" & oldField[5] & "\r" & oldField[6]
I've used the "\r" to mean the pilcrow or return-character used in the
calculation dialog. You can place returns or spaces or commas or whatever
you want to "delimit" the items.
You reference the "repeat" with the "[" & "]" and the repeat number. Older
versions of FileMaker required using the "GetRepetition ()" function. The
parameters for this function ask for the field name and the repetition
number.
Beverly
