How to model a foreign key that only accepts a subset of keys in Designer?

From: Andrew Hardy <nobody_at_spam.from.news.AdvanticaTech.com>
Date: Wed, 18 Sep 2002 14:55:24 +0100
Message-ID: <ama0ne$smd$1_at_sun-cc204.lut.ac.uk>

Hi,

[Quoted] I have a table of Vehicles, I also have a table that is required to record [Quoted] events against Vehicles *but* it is intended only for those that travel on the road.

[Quoted] How can I model this (preferably in Designer) to prevent data being entered [Quoted] for the non-road going vehicles?

Andy

--
Opinions are mine and do not necessarily reflect those of Advantica
Technologies Ltd

Received on Wed Sep 18 2002 - 15:55:24 CEST

This message: [ Message body ]
Next message: Jirka: "FTree shows only a part of entries"
Previous message: Brian E Dick: "Re: Data model or ER diagram"
Next in thread: Neil Emery: "Re: How to model a foreign key that only accepts a subset of keys in Designer?"
Reply: Neil Emery: "Re: How to model a foreign key that only accepts a subset of keys in Designer?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message