not allow duplicate serial numbers to be scanned into form

Hello have attached sample db.
if you open db- open form- you will see serial number- i want users not to be able to add the same serial number more than once.
If I make serial number primary key in table- I get message box saying- 'you can't go to that specific record' - is that how I should do it? ( and then can I change message?)
or in this database should I be not allowing duplicate serial numbers in some other way?
thank you
onedb.mdb
davetoughAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
You can make a Unique Index for SSN and use the Auto Number for the Primary Key.

See image ... and modified db.

mx
onedb.zip
Capture1.gif
0
 
davetoughAuthor Commented:
thank you - i am going to have to look at this to understand-
i am not sure how you created the window ( indexes: tbl1) - maybe I have to just look at it more
thank you
0
 
davetoughAuthor Commented:
just found in design view of table under view menu-thanks - i have some things to learn
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Sorry ... was about to post that and got a phone call.

fyi ... you can use this window to create unique Compound Indexes one two or more fields - to make a unique combination of fields - should the need arise ...

mx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.