Jon, that's actually what i did.. perhaps the names of the tables aren't very explicit because i came up with the many branches/company later.. here's my structure
i have three tables: subarea: subarea belongs to an area which belongs to a city.. but each branch will just belong to one subarea company: general info about the company branch: this table has a company_id and a subarea_id field and other details about the branch... what i'm trying to figure out is how to setup the relationship between them.. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---