how to prevent dublication in the three field?

[mezzanine1974]

Suppose that there is a table where field names are A, B and C.
A-B-C variations never to be same. I mean such dublication should be
prevented:

A-B-C
2-5-9
2-5-9
2-4-9

Line 1 and Line 2 above are dublicating. How can I prevent ?

 

[Stefan Hoffmann]

hi,

Suppose that there is a table where field names are A, B and C.
A-B-C variations never to be same.

Create an unique index including your three fields.


mfG
--> stefan <--

 

[mezzanine1974]

thank you !