Re: N all-way relationship

--- Ryan  wrote:
> This is largely related to cross referencing part numbers

Why not
table master_part(  part_id int primary key, part_no not null unique, ... );
table vendor( vendor_no primary key, ... );
table vendor_part( part_id int primary key default(seq), vendor_no references vendor, master_part references master_part( part_id ), vendor_part, constraint unique( vendor_no, vendor_part ), ... );

Everything here is nice and normal (use part_id to avoid compound
primary keys).  Then use views for all cross referencing.



__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com