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

Andy

[Quoted] For the Logical Model, I would sub-type the vehicles entity.

What you are trying to show is that events can only be applied to road-going vehicles.

HTH Neil

[Quoted] "Andrew Hardy" <nobody_at_spam.from.news.AdvanticaTech.com> wrote in message news:ama0ne$smd$1_at_sun-cc204.lut.ac.uk...
> Hi,
>
> I have a table of Vehicles, I also have a table that is required to record
> events against Vehicles *but* it is intended only for those that travel on
> the road.
>
> How can I model this (preferably in Designer) to prevent data being
entered
> 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 - 17:38:55 CEST