Path: text.usenetserver.com!out03a.usenetserver.com!news.usenetserver.com!in04.usenetserver.com!news.usenetserver.com!nx01.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail Date: Sat, 07 Jul 2007 10:51:45 -0700 From: DA Morgan Organization: Puget Sound Oracle Users Group User-Agent: Thunderbird 1.5.0.12 (Windows/20070509) MIME-Version: 1.0 Newsgroups: comp.databases.oracle.misc Subject: Re: Enforcing one-to-many relationships References: <468fbbd5$0$8716$ed2619ec@ptn-nntp-reader02.plus.net> In-Reply-To: <468fbbd5$0$8716$ed2619ec@ptn-nntp-reader02.plus.net> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Message-ID: <1183830703.674281@bubbleator.drizzle.com> Cache-Post-Path: bubbleator.drizzle.com!unknown@216.162.218.178 X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/) Lines: 17 X-Complaints-To: abuse@csolutions.net Xref: usenetserver.com comp.databases.oracle.misc:248755 X-Received-Date: Sat, 07 Jul 2007 13:51:44 EDT (text.usenetserver.com) John wrote: > What's the best way to enforce a one-to-many relationship? It's not a > zero-to-many relationship - I need at least one entry in the child table. > > Thank you for any advice > > John > > (I don't want replies from Sybrand Bakker) Then you won't get one from me either. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.org