From: Scott Hamm Date: September 26 2005 5:59pm Subject: INDEX List-Archive: http://lists.mysql.com/mysql/189570 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_521_7993878.1127757592107" ------=_Part_521_7993878.1127757592107 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 QAI= D 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 ca= n not used by different QAID -- Please avoid sending me Word or PowerPoint attachments. See http://www.gnu.org/philosophy/no-word-attachments.html ------=_Part_521_7993878.1127757592107--