I know MS Access uses AutoID fields to generate a unique number (which i what i use as my PK within my DB), but how do i keep track of unique numbers which are generated within my DB which an end user needs to use/see? My example is this:
Each item which my asset management program tracks has a unique Barcode (just a number string) which is generated (+1 to the next number). When a user adds a new asset into the system, how do I check to see what the next available number is in the system before assigning it?
My FE is MS Access and my BE is MSSQL 2012