Help

Creating a company hierarchy (Parent/Child)

Solved
Jump to Solution
2771 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Scott_Callery
6 - Interface Innovator
6 - Interface Innovator

Is it possible in Airtable to create some kind of company hierarchy such as:

Company 1 (parent)

  • Company A (child)
  • Company B (child)
  • Company C (child)

Company 2 (parent)

  • Company A (child)
  • Company B (child)
  • Company C (child)

To try and help you understand what I have and what I want to achieve, I have simplified my base as follows:

I have an Accounts table:
Accounts

I have a Projects table:
Projects

I have a Tasks table:
Tasks

What would I need to do to find out (link) which projects/tasks Company 1 (parent company) are working on?
As a start, in the Accounts table, I created a ‘Parent Company’ field that is linked to the Accounts table (I’m not sure if this is right or not) but I can’t figure out the next steps.

Can anyone help?

1 Solution

Accepted Solutions
Justin_Barrett
18 - Pluto
18 - Pluto

One possible solution is to reverse the parent/child linking process. Instead of linking each child to its parent, link the parent to all of its children (and of course, rename the {Parent Company} field to {Child Company}). In your example, Company 1 and Company 2 would each have three links. That will allow you to perform lookups and rollups of all projects and tasks for those child companies.

See Solution in Thread

1 Reply 1
Justin_Barrett
18 - Pluto
18 - Pluto

One possible solution is to reverse the parent/child linking process. Instead of linking each child to its parent, link the parent to all of its children (and of course, rename the {Parent Company} field to {Child Company}). In your example, Company 1 and Company 2 would each have three links. That will allow you to perform lookups and rollups of all projects and tasks for those child companies.