D
dennis g
Guest
Currently we issued case numbers to officers in the field manually. The case number is made up of the last two digits of the current year, the two-character station number for the officer, and a 6 digit case number. Example: 0152003498. We also log the officers badge number when we issue it, for obvious reasons. I'd like to automate this and put it out on a network drive so the officers can get their case numbers without calling in. The case number has to increment by 1 over the last case number issued. I'd like to prompt the officer for his idcard, his station number and the criminal code (3-6 characters). Only the station number is used to generate the case number, I want to store the other two items with the record. Any bites?