Aplogies for the picture. Picked the wrong one.
In any case, my data bases go way back to the early days of Filemaker when Repetetive fields were the only option. Thus, over the years this has carried thru to our present version using FP11. With all the data we have, to make a major change woud be an enormous undertaking frought with risk.
It does not make sense to me that the function does not work as it logically should.
Any help is welcome.
It does work as it logically should.
If the cursor is in the 3rd repetition of a repeating field, this function returns the number 3.
Splitting repeating fieilds into multiple individual related records may be easier than you think. FileMaker comes with an option for that which can make it a pretty straight forward transition.