I have several companies in my "Companies" table that are Parent Companies. I have several Subsidiary's of the Parent Companies listed as Companies as well. How can I relate the Subsidiaries and the Parent Companies to each other? I also have contacts that need to belong to both the Parent Company and the Subsidiary Company. On the "Companies" table I want a place for if you select the Parent Company to select and relate its Subsidiary Company and visa versa. Then I need a way for the contacts to be able to be related to either the Parent Company, the Subsidiary or both if needed.
Hope this makes sense. I am very new to QuickBase and appreciate any advice.
Question
How can I create and relate a Parent Company and a Subsidiary Company
This topic has been closed for replies.
+17Hi 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?
Wow I really appreciate all the info. I think I will make a copy of my app and try to make all the changes and if I mess up I can use the copy too make sure I am back to where I started. I will give it a shot and let you know how it goes.
+17Not a problem at all Mark, I have built some similar use cases in my own apps before. Your end result will be a little rough but you can always stream line it and clean it up over time to better suit your needs.
I had the same problem with jobs (parent/child jobs) as well as customers.
It's a little confusing at first, but I kept all customers in one table and created a relationship customer-customer. This allows for a company to be a parent or subsidiary. I hadn't looked into any of the implications of doing it this way, but maybe someone can come along and tell my why it's not a recommended option? :)
On jobs for example - our form has a 'related jobs tab' you can either assign the parent or view child jobs from the tab.
It's a little confusing at first, but I kept all customers in one table and created a relationship customer-customer. This allows for a company to be a parent or subsidiary. I hadn't looked into any of the implications of doing it this way, but maybe someone can come along and tell my why it's not a recommended option? :)
On jobs for example - our form has a 'related jobs tab' you can either assign the parent or view child jobs from the tab.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.