a txtSchoolID is automatically created when an admissions record is first generated / inquiry first made.
I believe the first few digits are the TIME that record was first made e.g. 103341705547 was at 1033 and 084849888271 at 0848.
Can we PLEASE change it so that it doesn't have a leading zero, is just a pain!
Leading 1 would be good. Or if there's any concern about duplication of existing values, how about prefixing it with a 2 digit year? i.e. all of this year's new records would have txtSchoolID beginning with 25
Even if they all started with a 1 this would be OK. Just have 1..... and then the usual code that follows normally. Simple fix?