Re: circular relationships URGENT

Hi!

Fernando wrote:
>
> Hi!
>
> I have the followinf entities: customer, order and address. A
> customer may have n addresses (shipping, billing, gifts, etc...) and n
> orders.
>
> First, I was planing to set a 1 to n relationship from
> customer to address and another 1 to n from customer to orders.
>
> Then I noticied, that I wouldn't have a way to know where (to
> wich address) an order should be sent....
>
> If I set a relationsship from address to order, the whole
> thing would be a sort of circular relationship (address to customer to
> order and back to address).
>
> I've never seen this sort of thing, so I'm afraid it must be
> wrong... What's the best solution? O:-)

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.

hth
Heinz Received on Mon May 08 2000 - 00:00:00 CEST