Head office, Branch, Employee what's the best structure?
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?