MS Access - Create s/n from two fields
Posted on 2014-12-11
I am building a database to create serial numbers for parts by combining two manually entered fields and one incremented field. The entire serial number will look like this:
The last three digits need to increment for anything with the same PartNo (the location number is not part of the serialization, only the final number itself if that makes sense). So when a user creates a new Full Serial Number, they enter the PartNo and Location into separate fields. The form should then lookup for anything using the same PartNo and then give the next available UniqueID, and then combine all three fields to makeup the Full Serial Number.
I hope that's clear enough. If not, please let me know.
Thanks a bunch!