Re: Simple data modelling problem.

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:35:00 CEST