[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Unique constraint on part numbers
- Subject: Unique constraint on part numbers
- From: woodvorg <..hidden..>
- Date: Sun, 15 Jun 2008 18:47:09 -0700 (PDT)
Why is there no unique constraint on the partnumber field of parts? To me it
doesn't seem right; a part number should be a unique identifier for each
part.
Easy fix, I just altered the parts table with a unique constraint, but this
produces nasty looking errors if you try to create a duplicate part.
--
View this message in context: http://www.nabble.com/Unique-constraint-on-part-numbers-tp17856631p17856631.html
Sent from the Ledger SMB - Users mailing list archive at Nabble.com.