I don't work much with repeating fields either as there are much better alternatives for almost any use of a repeating field and this has been mostly the case since the release of Filemaker 3.0. (But my current job came with a database that has repeating fields and now I have to work with them while working out a plan to replace them with a better database design...)
IsEmpty ( L1t Parameter[Get(CalculationRepetitionNumber)]) ;
Template::Parameter Default Value [ Get(CalculationRepetitionNumber) ] ;
the result fields repititon number has to be the same as Lt1Parameter
Yep. I had that in mind with my last post. With a calculation field that is a repeating field, this is something that you specify in the number of repetitions box in the lower left corner of the Specify Calculation dialog box. The Get(CalculationRepetitionNumber) function then returns a different value for each repetition of the calculation field.
you have lost me! I cant find anywhere to specify number of repitions.
this isn't a script.
Yip but i cant use the Self expression in a specify calculation field
should have stated the field was auto-enter
Not going to use repeating field after all because of their limitations, used a related table instead!
I agree that a related table makes more sense, but in an auto-enter calculation, you specify the number of repetitions on the storage tab in the field options dialog.