I am trying to build an Access 2003 database to be able to scan serial number ranges in and have Access expand those into a new table with each serial in the range. The new table has the serial as the primary key, which should prevent against duplicates.
I would also like to have the initial input validate that the quantity received is equal to the number of serials in the range.
I have not used Access in several years but I have got the tables and form built. I just need to know how to automatically do the validation. Perhaps also something to alert the user to a duplicate serial.