I have started using Airtable recently and I find it quite useful. I am trying to create a structure as below:
Company [All the companies that I worked/work with]
==> Project [All the projects that I have worked/working]
====> Tasks [All the tasks for different projects]
To achieve the relation, I have used ‘Link to another record’ field type.
I am able to relate Company table with Project, Project table with Tasks. On the Tasks table I am able to see the Project they are associated with, but on the Tasks table, I am not able to display the Company associated with the project for which the tasks are.
Can you please guide me how I can establish this structure?