Its duplicated data because you are already storing which branches belong to a company via the users table (users belong to a company AND a branch).
If you use a nullable foreign key for the branch id you can also represent people who are in the company but not associated with any particular branch. As with most things in life, there are many right answers. You just have to pick which one is best for your particular needs. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---