I have FM8 Pro Advanced. I have ieldA with 10 repetitions. I want to
write a script to create fieldBwith data from all 10 of the repetitions
of fieldA. I can do this by writing out 10 set steps to create fieldB,
but that's an inelegant way to do.

I was told FM8 lets you do a lot more with repeating fields. Is this
true and, if so, how would I accomplish task in an elegant way?

Thanks,

Rich

Rich,

Do you mean, transform the ten reps of FieldA into ten records of FieldB?
That is accomplished using an import that splits repetitions, usually.

A calculation by itself cannot create records.

If the two tables were related, you could also use, in FieldB of TableB

GetRepetition ( TableA::FieldA; Get ( RecordNumber ))

which will pull across the matching repetition from FieldA of TableA. (But
only the first record returned by the relationship!)

Bill

"Rich Sagall" <rich.sagall (AT) pobox (DOT) com> wrote