circular relationships URGENT

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:-)

TIA Received on Sun May 07 2000 - 00:00:00 CEST