You can find solutuion to a similar problem in Re: Expand data with Select statement? Message #806012.

>Ok i have a table
>
>client
>======
>ident i
>name c(50)
>nbarticle i
>
>values
>
>-1,robert,5
>
>so iwant to have a record like that
>
>RECORD
>
>1,robert,1
>1,robert,2
>1,robert,3
>1,robert,4
>1,robert,5
>
>it is possible