how to prevent dublication in the three field?

M

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 ?
 
S

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