Re: Reference table and primary key

From: Phil Goden <noble_at_audiophile.com>
Date: Tue, 25 Sep 2001 07:40:53 +0100
Message-ID: <yCVr7.372$L4.95261@news6-win.server.ntlworld.com>

My intention is to not have to make an entry into lu_group_process for every entry lu_group but for a set of A to Z range. I.e.: using lu_group.id 1 to 4 is one set of A to Z and I would like to refer to this set of rows (by lu_group.rangeNumber).

The only other way I can think of achieving this is to user trigger but I want to only use trigger as a last result.

Phil

"Galen Boyer" <galenboyer_at_hotpop.com> wrote in message news:uadzjyc1r.fsf_at_verizon.net...
> On Mon, 24 Sep 2001, noble_at_audiophile.com wrote:

> Why not have the lu_group.id field as your foreign key reference
> in the lu_group_process table and use a join to get the range
> number?
>
> --
> Galen Boyer
> It seems to me, I remember every single thing I know.
Received on Tue Sep 25 2001 - 01:40:53 CDT