Agnes,

I don't think you can solve this in VFP without Numbers table. In SQL Server you can use recursive CTE to create Numbers table.

BTW, Boris, I remember you created some very smart algorithm for 1+2^n records, but I'm afraid I didn't archive that thread - do you remember it?

May be we can create Numbers table in VFP using your idea and a few UNION statements.

>Hi Sergey,
>
>Be patient we me. Maybe I didn't see the solution
>
>My problem in your words
>
>How can I create (if possible) a cursor with the sequential numbers up to MAX(iChair) temporarly within a SELECT SQL and without an extra created cursor?
>
>Your first example simply creates 2*Reccount() records, I have expressed the problems. The second example runs on an extra cursor this is not what I'm looking for.
>
>So what do I miss?
>