Linking tables in both directions

I would like the 2 tables to be linked and dynamically filled in when I add information.
For example, in the Partners table, I want the names of the projects to be displayed automatically as entered in the Project table.

Hi Aurelie,

I’m not sure to undestand: if you add ADEME to Projet 06 for exemple, then Projet 06 is dynamically filled in column Projets-Nom in Partenaires table, isn’t it?

Yes, but I had to ask the help of a developer to do this.
I’m a designer and I was wondering if there was an easier way to do it