Ok I have a Job Form who use a table with those field
No_Auto
and
No
No is the number the user see and is entered manually and is a String cause it can be appended with letters...
What i want is when the user create a new Job my field for No gets automaticly the highest number from tbl_Job.No even though it's string... and might contain letters...
I don't know if it helps but the first 5 char of the strings are always the number, the letters come after