Hello!
Thanks for this quick explanation and for sure I can improve my intent !
Given 2 tables, Table 1 and Table 2 which are symetrical.
I want to link them in a many to many fashion (Table 1 can contain n Table 2 items and vice versa)
Resulting in the link to be visible by both table and to contain additional informations related to each specific link between any item of Table 1 and Table 2 such as a quantity or a price !
From your answer, I have the feeling that Anvil only supports one to many relationship and a many to many relationship should be written manually through a third table which would be the only one containing links to Table 1 and 2. Following my understanding of anvil table mechanism, I would think that Table1 and Table2 could not “show” Table3 in the DataTables interface because links come from Table3.