Re: Reference table and primary key

On Mon, 24 Sep 2001, noble_at_audiophile.com wrote:

> I am attempting to create the three tables listed below,
> however, the lu_group_process fails because rangeNumber is not
> a primary key nor has it a unique index. How do I get around
> this without building a compound key in lu_group and without
> having to include a compound key from lu_group on
> lu_group_process table.

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.