with two fields, Quantity and Repeat. Can I have a recursive calc. in the Repeating field that will sequentially fill each repeat based on the Quantity value.

so if Quantity = 6, this first six repetitions of the Repeat field would fill in accordingly:

1

2

3

4

5

6

Try:

Let (

i = Get ( CalculationRepetitionNumber )

;

Case ( i ≤ Quantity ; i )

)

brilliant, thanks again Comment

I thought this was going to be earth shattering new knowledge. The header hyped it way beyond, what could stick - I'm dissapointed! Where's the recursion?

What's the use for it BTW, to generate a fixed number of records by import between tables or something even better?

--sd