Hi Russel
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?
Michael Glaesemann
grzm myrealbox com