SELECT AVLBOOK INDEX ON GATE_NO TO AVLBOOK1 SELECT MAX(GATE_NO) AS MAX_GATE_NO FROM AVLBOOK INTO CURSOR V THISFORM.TEXT11.VALUE = MAX_GATE_NO