Currently, we hand-record all the serial numbers embossed onto badges into logbooks, and then use those logbooks to try to prevent future serial numbers from being duplicated. It’s a very manual and tedious process, full of opportunities for errors.
So, using C# and a local Access database (though this can be easily changed to a more complex database hosted on a server), I’ve been working on a Windows program that would replace the logbooks and instead record all serial numbers into the database, using SQL statements to ensure that there will be no duplications.