Unique combination for column values 2

[aspx]

Hi!
Is it possible to restrict combination of values of 2 different columns in a table to be unique (but values in each column not to be unique...)? And How?
Thanx for any help!

 

[AWithers]

If I understand what you are talking about then you need to add a primary key to the table based on the two fields which you want to have as a unique combination for the table

Andy

 

[KrisSimonis]

Another possibility is to add one table UNIQUE constraint on those 2 fields, if you don't want the primairy key to be those 2 fields.



Kris Simonis
Topdesk Information Systems