Re: Enforcement of 1 to many

Hi Cliff,

You could possibly do this through Triggers, but you will need to watch out for Mutating Tables (Trigger term).

Rgds
Andrew

Clifford Buetikofer wrote:

> Gurus,
>
> I need to enforce a 1 ( mandatory ) to many relationship between 2
> tables. Can the database do this or should we control it at the
> application level ? We do have a FK on the child table but how do we
> enforce ALL parents to have at least 1 child ? Procedurally ?
>
> TIA,
> Cliff
> ( I have 2 kids so I'm covered )
>
> The contents of this message express only the sender's opinion.
> This message does not necessarily reflect the policy or views of
> my employer, Merck & Co., Inc. All responsibility for the statements
> made in this Usenet posting resides solely and completely with the
> sender.
Received on Tue Apr 27 1999 - 08:53:25 CDT