Dear Exerts I need to display the Customer_ID on the form when user enter the info.e.g. if 100 records are saved when user goto form to enter customer info the record no 101 is shown But you know that when user submit the form then auto increment field is incremented 1 Customer Customer_ID Auto_increment First Name Last Name Address Phone
What is the solution? Imran Shafiq Khan [Non-text portions of this message have been removed]