Re: [GENERAL] Multiway associations

2004-01-25 Thread Paul Thomas
On 25/01/2004 05:06 Russell Shaw wrote: Hi, I'm making my first database. 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 "j

[GENERAL] Multiway associations

2004-01-24 Thread Russell Shaw
Hi, I'm making my first database. 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" ? -