I am working with menus in forms6
I create a menu for inserting record .
I wnat to select max value of branch_no from table and then add 1 to it
and to assing to branch_no filed of data block .
so how can i store the max value which i get by executing select sql statement using Host command in menu.
please help me.