How do I set Index to enforce that ONLY 1 QAID can own that order number, but nothing else?
For example: QAID [order] ErrorType 11223 123456789 19 'ALLOWED TO HAVE different ErrorTypes as long as one QAID number uses it. 11223 123456789 19 'VIOLATED cannot have same ErrorTypes -> UNIQUE INDEX (QAID,[order],ErrorType) 11223 123456789 15 11223 123456789 NULL 11240 123456789 14 'VIOLATED -- order was owned by QAID 11223, therefore can not used by different QAID -- Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments.html