Conditional Relationships ?

From: Henry Craven <GospodynNiemandt_at_nyet.net>
Date: Sat, 28 Dec 2002 21:51:10 GMT
Message-ID: <i1pP9.3885$aV5.8878@news-server.bigpond.net.au>

I'm curious as to how one would go about setting up and enforcing a Conditional Relationship.

An example would be :

Orders Table
Order_Items table
Invoices Table
Invoices_Intersect Table

The Invoices_Intersect has Foreign Keys for Invoices
Orders
Order_Items

The relationship needs to be enforced so that the Invoice relates to EITHER the Order ( as a Whole ) 1 -2- 1 OR the Order_Items ( Order part Shipped ) n -2- 1 BUT NOT both.

TIA
--

Henry Craven

---

Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.431 / Virus Database: 242 - Release Date: 17-Dec-2002 Received on Sat Dec 28 2002 - 15:51:10 CST