Here's a trick that works only if the SELECT involves a single table:

SELECT * FROM MyTable INTO CURSOR MyCursor NOFILTER
SELECT *, RECNO() FROM MyCUrsor INTO CURSOR MyFinalCursor

Vlad

>I'm just full of questions today. :)
>
>Say I have a table that looks like this:
>
>

>
>   master     item
>     1        apple
>     1        banana
>     1        pear
>     2        tomato
>     2        apricot
>     3        squash
>     4        turnip
>     4        orange
>
>

>
>I want to get this:
>
>

>
>   master  #   item
>     1     1   apple
>     1     2   banana
>     1     3   pear
>     2     1   tomato
>     2     2   apricot
>     3     1   squash
>     4     1   turnip
>     4     2   orange
>
>

>
>Is there a way to do this with SQL? It seems like there should be, but it's eluding me. I'm trying to number the items so I can combine a bunch of records into one in a different SQL so I can print the labels I was asking about earlier.
>
>Thanks,
>
>Michelle