Re: some design questions

"Alan" <alanshein_at_erols.spambuster.com> schreef in bericht news:8ivrmi$iaa$1_at_bob.news.rcn.net...
> You need three tables:
>
> Customer, Contacts, Warehouses
>
> Customer_ID is in each table.
>
> If you need to know which contact is in which warehouse, then put
 Warehouse
> ID in the Contacts Table, or use the next method:
>
> If a contact can be at more than one warehouse, then you need a m:n
> connecting table:
>
> Contacts_Warehouses
>
> which contains the Contact_ID and the Warehouse_ID
>

Thx Alan,

I did design it that way, but if feels reassuring to have somebody elses opinion. Thanks for your help.

Steven Tolleneer Received on Sat Jun 24 2000 - 00:00:00 CEST