Re: Simple data modelling problem.

Also!

Can't I just store all of the products for every supplier in the product table, and for each product store the relevant supplier?

Thanks,

Lee.

"Lee Osborne" <osbornelee_at_hotmail.com> wrote in message news:990005765.13303.0.nnrp-01.c2de1f0e_at_news.demon.co.uk...
> Thanks Tasxa,
>
> Could you give me some example select statements for say, display a
 supplier
> and their associated products?
>
> Hope no-one is laughing at me! ;-)
>
> Lee.
>
>
> "Tasxa" <taska_at_mailno.spam.com.net> wrote in message
> news:9dtg32$dgn$1_at_news.eunet.yu...
> > Assuming that you have TSupplier, TProduct, create a table TSupProd
 with:
> >
> > ID (key, autonumber)
> > IDProduct (from TProduct)
> > IDSupplier (from TSupplier)
> > and other fields necessary
> > HTH
> > Tasxa
> > "Lee Osborne" <osbornelee_at_hotmail.com> wrote in message
> > news:990002098.11778.0.nnrp-01.c2de1f0e_at_news.demon.co.uk...
> > > Hi all,
> > >
> > > I'm new to this so bear with my stupidity! I have a list of suppliers
 whose
> > > table structure is no problem. However, each supplier needs to have a
 table
> > > of products that they supply. Surely I don't need to create a products
 table
> > > for each supplier? Help!
> > >
> > > How do I solve this problem elegantly?
> > >
> > > Many thanks,
> > >
> > > Lee.
> > >
> > >
> >
> >
>
>
Received on Wed May 16 2001 - 11:48:51 CEST