Stoping duplicates over 3 fields

[scotlin]

Is there any way I can stop the same permutation of three field values being duplicated in a table.
eg
a - b - c is ok
a - b - d is ok
b - c - e is ok
a - e - c is ok
a - b - c ......duplicate

 

[pono1]

Create a composite primary key comprised of those three fields.

Regards,
Tim

 

[scotlin]

Thanks It works