How to make a column a primary key so duplicate records cannot be added

Question

I have a text column called JPPNum, and I want to make it so a user cannot add the same JPP Number if the record with that JPP number is already in there. So no duplicate on JPP NUm, how would I do that?

enter image description here

score 3 · Accepted Answer · answered Mar 13 '15 at 17:19

3

You can select Enforce unique values in columns settings.

More info in MSDN: Enforcing Uniqueness in Column Values.

answered Mar 13 '15 at 17:19

Juan Pablo Pussacq Laborde

3,369
1
16
24

How to make a column a primary key so duplicate records cannot be added

1 Answers1