How about

SELECT 1
SELECT max(BILLNO) FROM ALIAS() INTO CURSOR NEXTNUM
THISFORM.TEXT1.VALUE = NEXTNUM.BILLNO+1

>hi all,
>
>i put my code under to count how many bills i have at my table to increase for new bill
>
>any new idai.
>

>SELECT 1
>GO BOTTOM
>THISFORM.TEXT1.VALUE=BILLNO+1
>

>
>thanks.