Sorry for the newbie question but some of the other posts around the same topic don’t seem to quite address what I’m looking for…
In short, I’m using Airtable to manage a number of property developments. My primary field/column is a list of the addresses of each property. I would like the first table to be called ‘Tasks’, with each column representing a particular task in that development (ie. lodge planning approval). The second table would be called ‘Documents’, and each column would have a type of doc for each property (ie. feature survey pdf). Maybe a third table would include details of any tenants in the properties, etc. Most importantly, I would like to add a new property in one table, and have the primary field in each table also add the new property.
What’s the best way to do this? Am I better to leave everything on one very large table and achieve it using different views? Or separate tables and sync or link the primary field?
Any help would be appreciated!