Airtable with field link

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

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.