View Single Post
  #1 (permalink)  
Old October 2nd, 2003, 07:29 AM
jammykam jammykam is offline
Registered User
Join Date: Oct 2003
Location: , Surrey, United Kingdom.
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default checking for duplicates

I have a database of serial numbers which are added to on a regular basis. At the moment there is about 30,000 and growing (consisting of ID, Serial#, JobID). These numbers are scanned in using a barcode reader directly into the access through forms which are in table view. Problem is that stock is often recirculated back to us so we need to know when this has happened.

I thought of simply setting the field to allow no duplicates but sometimes the stock will be kept anyway and therefore duplicates will exist. Is there any way I could pop up a message box maybe to alert the user that this number already exists in the database and then let them make their own mind out (they are semi-compenent users if such a thing exists!).

Any thoughts?