you can use a repeating calculation field with this calc:
values = List ( rep1 ) & ¶ & List ( rep2 );
GetValue ( values ; Get ( CalculationRepetitionNumber ) )
where rep1 and rep2 are the names of your 2 repeating fields.
Hello Danielle, thank you for your solution (kindly edited by raybaudi) which I will try today. It looks good.
I'll let you know of results.
Unfortunately it didn't work as I neglected to tell you that I'm still using fp7. I have fp9 but haven't upgraded because of computer issues (which will soon be solved).
The List function is not implemented in fp7.
I'll try to figure another way around it because you've given me a good start.
Let say that you have 2 repeating fields ( rep1 and rep2 ), each one with 5 reps.
The calculation for a third repeating field of 10 reps will be:
n = Get ( CalculationRepetitionNumber );
n ≤ 5 ; rep1 [ n ] ;
rep2 [ n - 5 ]
Thanks Daniele, I'll give it a try tomorrow as I'm too busy today (Valentines Day!)
I hope you have a good day.
Thanks Daniele. It works fine.
You certainly know your FileMaker functions. It took me some time to work out what happens but I got it in the end.