When you create a summary field that aggregates a repeating field, you have the option to aggregate the individual repetitions, and the summary field itself becomes a repeating field.
That being said: are you sure that repeating fields are the best way to store your data?
Thanks for your reply. Since portals can't display records horizontally, I can't think of another way to do this cross-tab layout. There will never be more than 16 classes per course, but there can be any number of detail tasks needed to complete the update. So my thinking is that the variable number of detail tasks would be displayed in a portal with the fixed value of class titles across the top.
I could be wrong, but the option to aggregate individual repetitions works only in a summary field which can only summarize fields within the same table. I want each repetition in the ClassUpdateStatus::Status field to be True if the sum of the corresponding repetition in ClassDetailStatus::Status field is equal to the number of detail records. So in the screen-print above showing "Class Level Updates", class 3 an 7 would be blank and class 10 would be set (X).
So you do need a summarized repetition / repeating summary.
In ClassDetailStatus, create ClassDetailStatus::sSumOfStatus with individual repetitions;
Now – if (Big If) I understood correctly, the calculated repetition field ClassUpdateStatus::Status would read:
Let ( [
i = Get ( CalculationRepetitionNumber ) ;
relatedSumRepetition = ClassDetailStatus::sSumOfStatus[i] ;
relatedCount = Count ( ClassDetailStatus::primaryKey )
relatedSumRepetition = relatedCount
More explicit than necessary to better bring the point across.
Since portals can't display records horizontally, I can't think of another way to do this cross-tab layout.
There are a number of approaches to this challenge of cross-tab reports; repetitions are one of them, but this is for display; you should not compromise a properly normalized data model for display purposes.
Anyway, another approach is a Virtual List; or just search for crosstab filemaker.
Thanks Erolst. As usual, you came through again. This worked.