Hello, I have 3 tables under airtable (Image 1, 2, 3).
They have data linked to each other and I want to do CRUD on my "products" table (Image 1).
How do I keep the links between my tables?
Thank you for your help
Fred
Image 1 :
Image 2 :
Image 3 :
AirTable has an API ? I guess if you use that, it maintains the relational links ?
I have an API key in Airtable. But I don't see how to create a product and put the relationship between the 2 tables.
I'm looking through MySQL to see the relationship between the tables and manage them but I can't find it.
All I find is tables with raw data, no linked data between the tables.
I would have thought you would run a SELECT query that reads across tables
for example:
note: sorry, I do not use / have never used AirTable....
Start with a Google search for AirTable Relational Integrity.
Then try Air Table Foreign Keys
Oh my god,
it's very complexe but thank you for your response but it''s very difficulte for me.
