Hi Sergey,

Thanks for the help.

I need

MAX(iChair) 

right ?

Your solution returns something like 2* (number non deleted records) with unpredictable numbers. (As soon as something is deleted).

and even for a cursor with only undeleted records it would fail for

CREATE CURSOR curTable (cTableNumber c(1), iChair I)
INSERT INTO curTable VALUES ('4',6)

Agnes

>Hi Agnes,
>
>Try
>

>SELECT cTableNumber, cTableNumber + "." + TRANSFORM(sn) AS cChairNumber ;
>FROM curTable ;
>	JOIN ( ;
>			SELECT RECNO() AS sn FROM curTable ;
>			UNION ALL ;
>			SELECT RECNO() + RECCOUNT() AS sn FROM curTable ) crsNumbers ON curTable.iChair >= crsNumbers.sn
>

>
>The inner select with UNION creates a Numbers table. You can create it any way that works for you. Just make sure that it hold sequential whole numbers with max value not less than # of chairs. For example
>

>* Create numbers table
>lnMaxChairs = 8
>CREATE CURSOR crsNumbers (sn i)
>FOR i=1 TO lnMaxChairs
>	INSERT INTO crsNumbers VALUES(i)
>ENDFOR
>	
>SELECT cTableNumber, cTableNumber + "." + TRANSFORM(sn) AS cChairNumber ;
>FROM curTable ;
>	JOIN crsNumbers ON curTable.iChair >= crsNumbers.sn
>

>