I’ve gone from knowing nothing about Airtable to feeling I have a grasp of the main principles. I am building an ever more complicated database that has moved into the daunting complexities of off shore financing.
Upto now I have around 10 tables that handle People, Business names, addresses etc.
Till recently I thought a (2 way) linked relationship between people and businesses (in different tables) would work well but now I need the same 2 way link between different businesses. At the moment I have one table for all businesses and knowing the exponential growth in data Im not sure how best to move forward and still maintain the 2 way link philosophy. I thought to start adding more tables to create a hierarchy of businesses but that seems too much. I also thought about trying to use lookups but can’t figure out how that would work.
I tried a script that auto populates (children) linked fields based on the columns you point the script at but its not really ideal either.
Any ideas on how to move forward would be much appreciated…Am I now in the land of needing to write scripts which i’ve never done before?
You can link records to other records in the same table if you want.
If you give me more info on what exactly you are looking to achieve as an end result I would be happy to help.
Im finding it hard to explain but bare with me…
I have a table called businesses. In this table I have a column which is a linked field to the same business table called ‘related businesses’
In the ‘related businesses’ column for Business1 I fill in a cell and type ‘Business2’ , Business2 doesn’t then populate with Business1
Does that make any sense?