circular relationships

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:-) The neptune db stores the addresses in the orders table. I don't like this too much, since it repeats the addresses over and over...

TIA
//-----------------------------------------------
// Fernando Rodriguez Romero
//
// frr at mindless dot com
//------------------------------------------------
Received on Sun May 07 2000 - 00:00:00 CEST