Re: Simple data modelling problem.
From: Tasxa <taska_at_mailno.spam.com.net>
Date: Wed, 16 May 2001 10:56:27 +0200
Message-ID: <9dtg32$dgn$1_at_news.eunet.yu>
Date: Wed, 16 May 2001 10:56:27 +0200
Message-ID: <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 - 10:56:27 CEST