Conditional Relationships ?
From: Henry Craven <GospodynNiemandt_at_nyet.net>
Date: Sat, 28 Dec 2002 21:51:10 GMT
Message-ID: <i1pP9.3885$aV5.8878_at_news-server.bigpond.net.au>
I'm curious as to how one would go about setting up and enforcing a Conditional Relationship.
Date: Sat, 28 Dec 2002 21:51:10 GMT
Message-ID: <i1pP9.3885$aV5.8878_at_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 - 22:51:10 CET