quote:Originally posted by Shawn Mohan
Yes once the user submits the form I want the reference number to auto increment.
My guess is you're using the included SQL Server Express db. If so, doubleclick the table you want to have an incrementally updated column for, then click the field in question (your_ID). In the Column properties, set Identity Specification to Yes and open its properties by clicking the + sign in front of the Idendity Spec. text.
Next, choose your values in increment (how big jumps you want) and also seed (the first value). That's it!
Coding is indeed a nine-to-five job; nine pm to five am.