Sorry, I misunderstood you.

-----Original Message-----
From: Svein Erling Tysvar
[mailto:svein.erling.tysvaer@...]
Sent: Wednesday, April 03, 2002 2:42 AM
To: ib-support@yahoogroups.com
Subject: Re: [ib-support] Design question


No Reggie, we don't disagree! If companies may have more than one address
of interest (I don't know any of Nico's customers), of course it should be
in a separate table.

I was just trying to say that if this wasn't the case and that every
customer had one and only one interesting address (and an address which
typically wasn't shared with other customers), then I saw no need for a
separate CUST_DELIV table.

I completely agree with everything you wrote,
Set

>I disagree, you should separate the data to a CUST_DELIV Table.
>Each customer could have more than 1 delivery location.
>
>You should think of your tables as single entities.
>Your Customer table should ONLY have information that pertains to a single
>Customer (i.e. what makes up a Customer).
>
>Just my 20000 * 10^-6 cents.

To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/