AnsweredAssumed Answered

Head office, Branch, Employee what's the best structure?

Question asked by ianmanning on Jun 8, 2010
Latest reply on Jun 8, 2010 by ianmanning

Title

Head office, Branch, Employee what's the best structure?

Post

I have a CRM database with companies and employees in separate tables related by a key field. Some of our companies have a head office with sub branches.

I want to be able to show the related branches if I look at any of the branches or employees.

I assume the best structure will be to add another table for head office  and add another Key & foreign key.

The number of companies with sub branches is very small compared to single site companies and I was wondering if there are any other ways to achieve this?

Thanks

Ian

 

Outcomes