SELECT max(BILLNO) FROM ALIAS() INTO array laDummy
THISFORM.TEXT1.VALUE = laDummy + 1 && same as laDummy(1)+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.