trigger help

From: Kenny <karosenb_at_erols.com>
Date: Mon, 15 Nov 1999 10:30:23 -0500
Message-ID: <3830270E.D5671C08_at_erols.com>


[Quoted] I have a table called 'SHOW' that will soon be changed to allow an end user to associate a 'SHOW_ID' with a 'channel_ID' or an episode_ID (but not both). This means that show will contain nullable FKs to channel and network. Can I write a mutex trigger to require that one is set but not both?

if so can somone provide an example?
thanks
-Kenny Received on Mon Nov 15 1999 - 16:30:23 CET

Original text of this message