Forum Discussion
EvanMartinez
Quickbase Staff
Hi Mark,
For scalability in the long term I would recommend planning to build that out so that you have three tables. One for Parent Companies, one for Subsidiaries, and one for Contacts. This way you can have Parent Companies that have Subsidiaries and then both Parent Companies and Subsidiary Company can be related to Contacts. This way you can have a nice flow from Parent Companies to Subsidiary and then from both those tables to Contacts. This keeps all of your data organized and flowing in a way that breaks down the two types of companies you have. Unless you have a use case where a company would be both a Parent and a Subsidiary?
For scalability in the long term I would recommend planning to build that out so that you have three tables. One for Parent Companies, one for Subsidiaries, and one for Contacts. This way you can have Parent Companies that have Subsidiaries and then both Parent Companies and Subsidiary Company can be related to Contacts. This way you can have a nice flow from Parent Companies to Subsidiary and then from both those tables to Contacts. This keeps all of your data organized and flowing in a way that breaks down the two types of companies you have. Unless you have a use case where a company would be both a Parent and a Subsidiary?
MarkComish
7 years agoQrew Assistant Captain
So I would use my current "Companies" table for my Parent Companies. I would create a "Subsidiary Companies" table and move the Subsidiary Companies to that table. Then I would need to create a relationship between those two tables with "Companies" can have many "Subsidiary Companies." I would also need to create a relationship where "Subsidiary Companies." can have many "Contacts" like I have for "Companies" can have many "Contacts" already. Is that correct? Is there anything else I left out? On the "Companies" Table I can have a field to pull related "Subsidiary Companies" (Subsidiary) and on the "Subsidiary Companies" table I can have a field to pull related "Companies" (Parent) ? For the existing contacts how can I have them be connected to a Parent Company and a Subsidiary? Do I need a new field?