Can you explain me how to auto increment the value like LG/SALES/1000,LG/SALES/1001, LG/SALES/1002.............LG/SALES/1030
i Had a Form With a label When I Load The Form The label will be fill with Alphanumeric number, THEN it will be stored into sq.
2.after that when i load the form max value comes from database and it will be incremented
my table name is sales and column name is sales_invoice(auto incremented vales).