On Jan 25, 2004, at 12:46 PM, Russell Shaw wrote:
> I have a list of parts, each of which is sold by multiple
> vendors. I also have a list of vendors, each of which sell
> multiple parts.
> How should i arrange the tables for this that doesn't involve
> having lots of empty fields "just in case" ?
One common way to do this is to have three tables: one suppliers, one
parts, and one suppliers-parts referencing suppliers and parts.
Does that help?
grzm myrealbox com
In response to
pgsql-novice by date
|Next:||From: Bruce Momjian||Date: 2004-01-25 05:19:27|
|Subject: Re: Problem with pg_hba.conf file in Postgres 7.3|
|Previous:||From: Russell Shaw||Date: 2004-01-25 03:46:13|
|Subject: Multiway associations|