On 10/13/06, gremlin <[EMAIL PROTECTED]> wrote: > Keep addresses in an address table. > A join table could connect contacts to addresses - likewise for > companies and addresses. > Disallowing a company to have the same address as a contact is going to > eventually bite you in the ass. I for one do private contract work from > my home. My own companies address is my home address. I could be a > contact REQIURING a company address identical to my personal one.
Sure, but I don't rule out the possibility of two contacts/organizations having an identical address. But if they do, I want those addresses to be separate tuples in the addresses relation. Suppose your business grows and gets too big for your home. You want to update your companies address, but not your home address. That's not possible if both tuples point to the same address tuple. Regards, Martin -- Martin Schapendonk, [EMAIL PROTECTED] --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php -~----------~----~----~----~------~----~------~--~---
