Basic form setup Q.

  • Thread starter Thread starter Janet
  • Start date Start date
J

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
 
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
 
Back
Top