Re: circular relationships URGENT

"Fernando" <spamers_at_must.die> wrote in message news:58ldhsglfncjbdpoqqhq073t7iu1ej7tk2_at_4ax.com...
> On Mon, 08 May 2000 10:21:47 +0200, Heinz Huber
> <Heinz.Huber_at_elbanet.co.at> wrote:
>
>
> >As I understand you, it is no circular relationship:
> >
> >customer 1 : n addresses
> >customer 1 : n orders
> >address 1 : n orders
> >
> >The relationship customer to orders is redundant, but might be kept for
> >performance reasons.
>
> Hhmmm... OK, but actually I have two types of addresses (billing and
> shipping), so I would have an n to n relationship. Any ideas about
> how to make it 1 to n? O:-)
>
> TIA
i would have thought the following would cater for your needs

 >customer 1 : n addresses

i.e a customer can have more then one address. i.e billing and shipping. Received on Mon May 08 2000 - 00:00:00 CEST