Basic form setup Q.

[Janet]

Hi,
I set up an Access form connected to SQL2k tables.
I noticed that I can duplicate a field which has a unique number
(ContractNo). The latter is a 6 digit number and it shouldn't be duplicated.
How to I prevent it?
I even created a field called 'AlreadySaved' and I populate it with a 1
automatically when saving the data but I don't find a way to use it to
prevent duplication.
Any help is appreciated.
Janet

 

[Gary Miller]

Janet,

You will probably need to supply some more details. What is the field type
in SQL2K? How are you doing your inserts? Are there any constraints? Is this
supposed to be the primary key?

Gary Miller