Hi I am extremely confused by Airtables Linked records and dependencies. Former Access User - I am used to the process of a query design where one takes two tables, identify the matched field on both tables and then having the ability to create a new table with the records from both tables or update one table based on that field relationship.
In airtable I can’t see to find a way to do this.
I keep creating a linked record in airtable from one table to another and it’s empty.. if I make a lookup field up it wants me to add things but I have the data in both tables I just need to manipulate.
I have watched and read airtable instructions over and over and it’s not clicking!!
